DLookUp Default Value

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

How do you DLookup the Default Value of a field in a table.

Me.TxtVal = DLookup("ChkMessage","tblChecks")

Thanks
DS
 
DS said:
How do you DLookup the Default Value of a field in a table.

Me.TxtVal = DLookup("ChkMessage","tblChecks")
Click to expand...


You can't do it with DLookup, if I understand what you mean. DLookup can
return only values that actually exist in the table, not values that *might*
be added if someone adds a record without specifying a value for the field.

However, you can do it using DAO:

Me.TxtVal = _
CurrentDb.TableDefs("tblChecks").Fields("ChkMessage").DefaultValue

Bear in mind that the DefaultValue property is a string, and will be a
zero-length string if the field doesn't have a default value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Text 4
How do I do this in VBA? 5
Calling a function 2
Access ACCESS DLOOKUP INVALID USE OF NULL 0
Change value in a table using VBA 4
getting certain fields from a particular record 3
Dlookup minimum value 3
Control afterupdate - run from module - insert data - set flag 3

Back
Top