how to reference a field in the continous form

P

paul

Hi,
In my Access 2000 application, I have a subform
(continuous form, from an query result) it may contains 1
to 30 records. I tried to wrote an event for an field
(emp_no), how do I reference the field of a specific
records?
Thanks.
 
K

Ken Snell

You don't reference the field for a specific record. You either make that
record the one currently selected and then reference the field; or use a
recordset object that is a copy of the original recordset and then do a find
in that recordset object and use the value of the field from it.
 

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

Copy previous record into form field 0
DLookup in Continuous form 0
Populate main form from subform record 0
VBA code returns no records hwenKey ID is added 14
How do I clear a form? 0
looping thru a continous form 5
Field referencing - Continous Form 1
Get a Max value from a continous form's (subset) records 5

Top