I am new to access and I am having problems using this function. Basically I have created 1 form which stores data to a table with one field being the auto number field. On my second form I have a hidden field which I want the default value to be populated with the auto number of the last record created from the first from. Can anyone help me with the syntax.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using DLast function
- Thread starter moles
- Start date
you actually need the dmax function but it is pretty much the same
so your code would be.
me.hiddentxtBox = dmax("[recid]","tblname"
me.repaint
these two lines will make sure it's in there even though it is hidden.
when dealing with hidden controls - it's always advisable to leave them visible until they work.
jo
so your code would be.
me.hiddentxtBox = dmax("[recid]","tblname"
me.repaint
these two lines will make sure it's in there even though it is hidden.
when dealing with hidden controls - it's always advisable to leave them visible until they work.
jo
- Status
Similar threads
- Locked
- Question
