I have a 2 part question.



I have a form, based on a query.

Some of the sample controls on the form are called:

Date
Name
RunStatus
RunID
RunType
Vehicles

and a few more.

In the query, the RunID is formatted like this:

RunID: Format([Increment],"00" & Format([Date],"yy"))

Here is what I would like to do.

For controls like RunID, RunType, Vehicles, and others, I don't want them to be visible when the form opens. I only want these to be visible when the RunStatus is selected as "Yes". RunStatus is set as a drop down box with Yes and No as the options.

Here is the other part. If entries are made in other controls on the form, is there a way to prevent the autonumber function (and resulting ID) in RunID to not automatically number unless RunStatus has Yes as its value?

Thanks for the help...