Setting Current Record

  • Thread starter Thread starter JudyB
  • Start date Start date
J

JudyB

I have a subform with several fields, one of which is "DateOut". If this
field is left blank, I would like to set this record as the Current Record.
Can anyone provide help on how to go about doing this?
 
JudyB,
are you trying to get the subform to show only those records where the
DateOut field is blank?
If yes, in the query which is the recordsource for the subform, under the
field for DateOut put Is Null in the Criteria row and save the query.


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

help editing data 2
Setting record with null field as current record 1
#Name? - Killing Me 4
Query design 0
Calculation in a subform 4
First Subform record gets modified when closing form 3
DMax on existing record to increment serialized # fails 1
view a specific report based on the current info of a form 2

Back
Top