Quick And Easy One

[helphelphelp]

HI

I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week

With thanks

 

[ejstefl]

Go into the data properties of your form and set it to Data Entry

 

[ejstefl]

Go into the data properties of your form and set it to Data Entry. Or, if you are opening the form from VBA, set the data mode to acFormAdd.

 

[helphelphelp]

Data Entry

No, tried data entry this does not work, is there anything else I can do with this text box to run in conjunction with the combo box

 

[ColinEssex]

What did you set the forms property "Data Entry" to? . . . . . yes or No

Col

 

[helphelphelp]

Data Entry

I have tried both options, the form I am opening is to add a new vacancy to our system so the form needs to open blank and not attached to any records when opening but the form updates 2 different tables.
I first select the employee in the header of the form by way of a combo box and in the detail of the form I select the company that require a new vacancy this is also by a combo box called "centre name" their is another unique reference for the company that when you select the said company from the combo box, the unique reference number should come into a text box called "Centre No"this information comes from a table called "Centre List" the rest of the information required on the form are just dates and yes and no selections that are all working fine.
Can I put an afterevent in the text box to come in line with the combo box selection of the centre list, Im pulling my hair out here with this little problem