Open form to blank record

[barit]

I want to open a form to a blank record but I do not want to allow additions.

My form has a list box in the form header that is used to restrict records shown on the form. When I open the form I want just the list box to show without all the records from the list box showing below in the form.

Traditionally I have used DoCmd.GoToRecord, "", acNew Record to accomplish this. However, since I do not want to allow additions but just want the end-user to select and then edit the records and fill in one additional field, I am not sure how to accomplish this task.

I am currently using the following code
DoCmd.OpenForm "Form5a", acNormal, "", "", , acNormal
Domd.GoToControl "[List2]"
DoCmd.GoToRecord , "", acNewRec

As I said this works great if I allow additions, which I do not want to do.

I would appreciate suggestions on how to accomplish what should be a simple task.

Thanks

 

[PHV]

Perhaps setting the RowSource property of the form to an empty string, provided that the List2_AfterUpdate event procedure reset the RowSource (with choosen criteria).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[barit]

I am not sure what you are suggesting that I try.

Can you elaborate?

Thanks in advnace for trying to help