HOWTO: Text.DefaultValue = Table.Value

[Hans]

Hi,

I want to set the Text.DefaultValue = The first row and first column
of an table entry.

Or ist there another easy way to set a Textbox to a certain Value of a
table entry?


Greets
Hans

 

[Arvin Meyer]

Hi,

I want to set the Text.DefaultValue = The first row and first column
of an table entry.

Or ist there another easy way to set a Textbox to a certain Value of a
table entry?

You can use DLookup or a recordset to return the value you want, then set
the default value to that:

Dim x
x = DLookup("Whatever", tblWhatever", "ID='" & Me.txtID & "'")

Me.txtBox.DefaultValue = x
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Hans]

Dim x

x = DLookup("Whatever", tblWhatever", "ID='" & Me.txtID & "'")

Me.txtBox.DefaultValue = x

Thanks, that worked fine!


I' havent found the tip on http://www.mvps.org/access