limit to list - save to table not working

[p-rat]

I have a combo box with limit to list set to yes. The data comes from
a table. The table has two fields LeaseName and LeaseNumber.

When an end-user enters a value not in the list a form comes up to
type in the new LeaseName AND the new LeaseNumber. A text box pops up
asking 'do you want to add this value to the list?'. When clicking yes
I want the two value to be save to the underlying table. Currently it
is saving the LeaseName into the LeaseNumber field in the table and
the LeaseNumber value is no where to be found.

This LeaseName field combo box on the data entry screen also autofills
an unbound text box on the form (LeaseNumber) when the values are in
the list.

Would anyone know why these values are not saving to my underlying
table correctly? Thanks for any help provided.

 

[Gina Whipp]

P-rat,

When I use the NotInList event I open a form/menu for the End-User to fill
in the fields and requery the combo box once this form/menu has been closed.
You didn't mention if that is what you doing. How/Where are they entering
the information?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

 

[p-rat]

Yes. I have a form that pops up for the end user to enter in the
new LeaseName and LeaseNumber.

It doesn't want to save to the table correctly though.

 

[Gina Whipp]

Is the form tied directly to the table or is it a query? If a query can you
copy/paste the SQL of the query. Also, copy/paste the SQL of the combo box.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm

Yes. I have a form that pops up for the end user to enter in the
new LeaseName and LeaseNumber.

It doesn't want to save to the table correctly though.

 

[p-rat]

Sorry about the non-reply. I figured it out. Took a little time but i
had my underlying table hosed to where the bound column was incorrect.
I appreciate your time and help on this. Just want to make sure you
know I appreciate it. Thanks.

 

[Gina Whipp]

Thanks for feedback!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Sorry about the non-reply. I figured it out. Took a little time but i
had my underlying table hosed to where the bound column was incorrect.
I appreciate your time and help on this. Just want to make sure you
know I appreciate it. Thanks.