Opening form; data entry or not

[Egg 'n' Bacon]

Hi,

First off, great site (I've just got here from Woody's). Nice job, easy registration too

Next; what I'd like to do.

Rather than having 2 identical forms (1 for data entry, the other for review/editing), can I simply use a seperate button for each use on my menu?

TIA

[HansV]

Hi Egg'n'Bacon,

Welcome to Eileen's Lounge!

You can open a form in data entry mode (only allow new records) as follows:

DoCmd.OpenForm FormName:="frmCustomers", DataMode:=acFormAdd

And to open it in edit mode:

DoCmd.OpenForm FormName:="frmCustomers", DataMode:=acFormEdit

[Egg 'n' Bacon]

Cheers Hans, I knew you'd have the answer