Request data on upon running datasheet form

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

Guest

I have a datasheet form which is based on a query.

The query pulls information for attendees at events based on an 'event code'
column which links an 'event' table row and rows from an 'attending' table.

I want the user to be prompted to enter an event code if they chose to view
the form (but not if they choose to view the query). How can I do this?
 
Put the prompt in your form filter instead of your query. Or simply make
two queries - one for the form and one to run. The one you use for the form
does not even need to be a saved query, just enter it in the data source in
the form's property box. I do that often - build the query right in the
form, but don't save it as a named query. That keeps my database window
clean. There are no queries listed out there except the ones my users
should run standalone.
 
Back
Top