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
 
Go to Access Help and look at the parameters of the 'docmd.openform' statement

-Dorian
 
You must log in or register to reply here.

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

display number of records on form from date range 0
Open New Record in Form B with Data from Form A 3
Open a Form Based on 2 Criteria? 3
Filter data by using a form and open a report based on this data 1
Conditional Formatting based on dynamic Date 1
DataMacro problem after Splitting Access Database 2010 0
change field color 3
vba code question 14

Back
Top