On Load form error

[Bosakie]

Hello,

I am using the Microsoft 2003 Access Asset Managment database as a starting point. I have been working on updating the database to meet my requimments. Everything is working fine, but I get an error when launching the dataabase and the Assets form loads.

Clicking OK will bring up a screen to continue or debug. I click on debug and continued to run the form load and then the form worked without error. However, closing the database down and brining it back up produces this error again.

This time I clicked Cancel and got this message box:




The funny thing is, again, I click ok and the form works as expected. Not sure where to go to resolve this, but I have been thinking about not loading the form when starting the database.

[ranman256]

Its saying it cant find the field, make sure there is a box on the form called ASSETID.
make sure there is a form load event and see what is in there.

If ASSETID does exist, AND the query connected to the form using this param , then during form load it cant find ASSETID.
You cant fill in the textbox WHILE the form is loading.
You may want to remove the parameter in the query, UNTIL the user fills in assetid, THEN connect that query to the form.

It sounds like a timing issue. The assetid is not available until later.