New Recored

[Hunter86]

New Record

Hi,
i am making my first attempt on creating a database already read some post on here that have been a great help cheers !

i have a customer form and on that form is control to the order form, there is a onload event that creates a new record and inputs the customer number into the order form. Now ever since i have done this i have to click on a pencil on the left margin to enable me to input the data is there anyway i can change that? If the form is opened not using the button on the customer page its fine can enter data straight away and the arrow is present in the margin.
many thanks
Dan

 

[rio]

I can't imagine ur problem! please more detail or put some attachment example.

 

[Hunter86]

Dirty Data ?

I can't imagine ur problem! please more detail or put some attachment example.

[FONT=&quot]Hi thanks for your reply!

i have been told that the problem is because the data is dirty although i am not sure of its full meaning.

in my database you can navigate from the customer form to the add order form. when this navigation is made a new record is created in the add order form and the customerID is entered into the form from the onload script...

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
If Not IsNull(Me.OpenArgs) Then Me.Custid = Me.OpenArgs
End Sub

The add order form holds the fields for two tables,tblorder and tblorder description. It appears that i can freely enter data into the fields that belong to the order table but when i get to the fields on the form that source at order description i have to save the record or click on a pencil image in the top left margin which normally is a black arrow to continue with the data entry it is not a major issue as the data can still be input i just don’t understand it.

i hope that was a better attempt from me to explain what going on.
many thanks
Dan

[/FONT]