Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to handle blank boxes on form

Status
Not open for further replies.

adamstuff

Technical User
Sep 13, 2005
41
US
I've got a form with bound and unbound controls, text and numeric. What I'd like to do is have my user come in and see all blank boxes. If he fills the boxes (only 2 required out of 20) then hits CONTINUE command button, I want that saved as a new record. I think listing all the boxes and a DoCmd.SaveRecord would do the trick there.
If he hits CANCEL, I want nothing to happen except go back to previous form, with which I don't have a problem. That part's working
I know I'm dumb, but I haven't figured out how to make the bound boxes show nothing. I keep showing the previous record data. I thought about opening a new record on form open, but I don't know how to handle a new record that may or may not have had data put in if the user hits CANCEL.
Any suggestions, please?
How come I never had these Problems in Visual FoxPro?
TIA

Heisenberg was probably right.
 
probably easiest to use a totally unbound form, and "load" the bound values on form Open or something...

--------------------
Procrastinate Now!
 
If I understand you properly, when you open the form, your bound controls are populated with data from an existing record, which is not what you want.

Open the form's properties, and set the 'Data Entry' property to yes. When the form is opened, the bound fields will be blank.

- - - -

Bryan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top