HOWTO: Text.DefaultValue = Table.Value

  • Thread starter Thread starter Hans
  • Start date Start date
H

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
 
Hans said:
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?
Click to expand...

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
 
Back
Top