form with edit

[naveens27]

Hi,
I have a form which is for edit records, in this form I have a combo box which will allow you to select an Asset id(combo box) and populates rest of the fields.
Problem: When ever I open the form rest of the fields are populating with out selecting asset id. I tried following.
1.dataentry to yes and to no after loading, allow additions to no and yes after loading.
2. wrote macro so form goes to new record which I don't want to happen.
3. removed recordsource and made it availaible when form is loaded.
But none of the above worked, So please suggest me how can I resolve the issue.

Thanks,
Naveen.

 

[JamesMcS]

Hi, welcome to the forum!

It sounds like the form is just looking at the records that already exist in the table. The only way to stop that from happening would be, as you've said, to navigate to a new record, where all the fields would be null....