Conditionally open a form based on 3 criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to open a form conditionally. I have a daily journal and if the
date and station number exist (and the date is less than 3 days old) I want
to open the form, get the data so it can be edited. If there is no match on
the date and station number, then open it as add. If the date requested is 4
or more days old, then have it as read only. So …

If Date Station Number

more than 3 days old matched open as read only
3 or less days matched matched open in edit mode
not matched not matched open as acNew

I am not sure how to put these conditions on the LINK criteria. Maybe they
belong somehwere else, I don't know.

TIA
 
Back
Top