Can't find

[klee]

Thanks for the solution that you recommended. IT works out well,but the only problem is I have a find record button. If I changed the data entry from No to Yes, I no longer would be able to use the find record command.

Do you have a better idea in solving in this problem.

Thank you

 

[jwindon]

My understanding is that you want to HIDE the records, yet you want the user to be able to search records. Is that correct?

 

[jwindon]

The form needs to open to a new record. This can be done by a macro or code which specifies two actions:

1. Open the Form
2. Goto a new record.

Your choice as to use a macro or code.

The form itself may still be set to DataEntry: No.

My concern is that you are opening the form from a "Switchboard" as you stated earlier.

If this is a switchboard built by Access's SwitchboardManager, you will have to alter code on the form's OnOpen event to move to a new record. (run the macro/event).

Good advice to heed at the point is to avoid using this feature. Create an unbound form and create command buttons on it that will perform the navigational operations of your database. This approach offers MUCH more flexibility in a switchboard and moving objects around is accomplished with less difficulty.

 

[klee]

thank you very much