Showing blank records in forms

[Luther]

Hi,

I have an interesting question. How would you show a blank form every time,
althought the underlying RecordSource is pointing to a table? In other words,
I want to be able to always have the users view a blank form -- the
equivalent to "Add Record", even though the new records get appended to the
table?

Any help would be greatly appreciated.

 

[Dirk Goldgar]

Hi,

I have an interesting question. How would you show a blank form every
time, althought the underlying RecordSource is pointing to a table?
In other words, I want to be able to always have the users view a
blank form -- the equivalent to "Add Record", even though the new
records get appended to the table?

Any help would be greatly appreciated.

Open the form in Data Entry mode. This can be set at design time in the
form's property sheet (Data tab, set Data Entry to Yes), or can be
specified when you open the form in code (DoCmd.OpenForm "YourFormName",
DataMode:=acFormAdd).

 

[Luther]

Thank you very much for the info...

Open the form in Data Entry mode. This can be set at design time in the
form's property sheet (Data tab, set Data Entry to Yes), or can be
specified when you open the form in code (DoCmd.OpenForm "YourFormName",
DataMode:=acFormAdd).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)