Not in list problem

[DanW]

I will create a new database with just the one table and two forms, with minimal controls and the same code, and see if I get the same problems. If so I will post that.



I developed this project on an old laptop that developed a motherboard problem, had to be replaced, and I'm worried that something got corrupted. Starting fresh would take a week off work to get it done again.

Thanks RG

Dan

[RuralGuy]

Sounds like a plan.

[DanW]

Well fortunately my simple database has the same problem as my project. So this part isn't corrupted. Hopefully less work.

Watch what happens when you enter your favorite new customer. You get blank last name, first name and dob controls. If you enter the customer ID again, you get the same thing. If you enter an old customer, it works. If you enter another new customer you end up with the newer customer ID with the old customer's names and dob.

The problem is that I want to get a new record bound to the mainform, not just the customerID.

Thanks,

Dan

Thanks for your help.

[RuralGuy]

What is it you expect the ComboBox to accomplish on the 1st form. If you want it to look up a customer and move the form to that record then create a new cbo and select the 3rd option. BTW, *both* forms should have a query as their RecordSource or you will find yet another problem. Why do you have any code in the OnChange event? It is not needed.

[DanW]

RG,

Thanks for your time. I created the record selector combo box with the combo box wizard, using the 3rd option.

I don't have a query between the table and form, my ignorance. I will do that later tonight. Do you expect that is the source of the problem? I'll let you know later.

As to the OnChange event, I could not get the combobox to dropdown without the onchange event. The combo box displays the last name, first name, and birthday with each customer ID to help make sure we have the right customer. It isn't needed to enter the customer ID, but it makes it easier to pick the right customer for my staff. They use another proprietary db that does the same thing. My biggest problem with the dropdown is that it won't dropup when I click on the right customer. I have to use the enter keystroke or click on the form detail to minimize the dropdown. I have a separate thread on that problem with no response, so would welcome your help.

Anyway, I will use a query as a recordsource and get back to you. Hope it works. Thanks, Dan

[RuralGuy]

If you press the drop down button on the right side of the cbo, the drop down happens. Isn't that good enough?

[DanW]

Well I have placed queries as the recordsource for each of the forms, but I do not get the desired change of being able to start entering data into the main form on a record for the NotInList added new customer.

Somehow I have to requery frmCustomers and reenter the new customers CustomerID again, which I have done successfully by using a command button to do a Me.Form.Requery event, and then reenter the new CustomerID.

I cannot figure out how to do that in the NotInList event. Is there a way to do that in code?

If not, is there code for the command button to get the form opened on the new Customer's record?

And you're right, the dropdown button is just fine for my employees.

Thanks again so much for your time RG,

Dan

[RuralGuy]

Hi Dan,

Give this one a try.

[DanW]

Thank you so much RG

and thanks for donating your valuable time for others

Dan

[RuralGuy]

You're welcome Dan.