T
Tina
I have a form that contains system information. I wanted
to be able to pull up one specific system's information at
a time. So I created a combo box in the header of the
form. It looks normal and offers the selections that I
want. However, when I click on my selection it gives the
following error message:
unknown or invalid reference [System Information.System_
ID].
This isn't an invalid reference. I've checked my queries
and tables to make sure that I've spelled it exactly the
same, etc. etc. My form has text boxes labeled both
Customer_ID and System_ID. If I use my combo box to pull
up records based on Customer_ID it works perfectly. So why
won't it work when I want only the record by System_ID?
I can't figure out what I'm doing wrong....Any advice
would be greatly appreciated. Thanks!
to be able to pull up one specific system's information at
a time. So I created a combo box in the header of the
form. It looks normal and offers the selections that I
want. However, when I click on my selection it gives the
following error message:
unknown or invalid reference [System Information.System_
ID].
This isn't an invalid reference. I've checked my queries
and tables to make sure that I've spelled it exactly the
same, etc. etc. My form has text boxes labeled both
Customer_ID and System_ID. If I use my combo box to pull
up records based on Customer_ID it works perfectly. So why
won't it work when I want only the record by System_ID?
I can't figure out what I'm doing wrong....Any advice
would be greatly appreciated. Thanks!