2nd Request - Combo box problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My form has 2 combo boxes which refer to separate tables. Both are set to open maintenace forms for their respective tables when new data is not on list. Combo box 1 works well, but then combo box 2 won't allow any input. I get this message in the statusbar: "To make changes to this field, first save the record." Can anyone offer guidance? TIA

Above is my previous message, which i left under forms. I'm not sure where to post it

Does ANYONE know how to fix this, or have i mis-stated my problem? This is a catch-22 that someone has to have encountered before. I can't save the record until i enter the data, and i can't enter the data until i save the record. What am i missing, here. Please help me , or can you refer me to another source. Thank you.
 
I think the lack of enthusiasm you are seeing is related to the
difficulty understanding your design.
I am not sure what you mean by "combo boxes refer to two separate
tables". Clearly, the new data can not be on the list, but what is it
"to open their respective tables"?
What are the combos supposed to do? Are they bound? What is their row
source? What is the form based on?
Please patiently and briefly summarize your design and state your
intention if possible, not just description of what is not working.
I am guessing that one combo is using an autonumber in its source that
has not been generated yet, but this is pure speculation.
Pavel
 
Gary,

What is the record source of the form?
Is DIRS using a simple AN primary key or is it a compound key?
If the combos are truly identical, there must be a difference in how the
foreign keys are used in the form's record source.
Do you have code executed by the combo box?

Pavel
 
If your db is not very big without data and you can post it on the web,
I'd be glad to take a look for you becasue so far I see no flaws in your
code, so something else must be wrong. If you can't post the db, lets
keep digging deeper.
Looks to me that combo box 2 is bound to a non-updateable join query.
Can you post the DIRS query? What events are used by the failing combo
box? Could you post code for those events?
You are saying that the error occurs immediately upon clicking. If you
are sure there is no code in GetFocus, KeyDown or Click events, one last
thing I can suggest is making another combo box, duplicating all the
functionality from the bad one and seeing if it works. I had two
instances in the last three years when a copy-pasted control just "went
bad", and making another and throwing the bad one away remedied the situation.

Pavel
 
Pavel
Thanks for you offer to help and your continued patience. I'm not sure how to post the database, so I've tried re-creating the combo box. In doing that, I discovered that 2 of my fields were not being called in the SQL. Both are memo fields. Is this a known trait of memo fields? Since neither field has data that exceeds the 225 limit, I'm going to try changing the field types to text and re-work both the query and the combo box. I'll let you know if that solves it. Thanks again.
 
Gary,
I hope this solves the problem. Re-post if you don't get it solved.
By posting I meant putting a ZIPped copy of the db after purging the
(confidential) data on a web or ftp site and sending me the URL by
E-mail so that I can pick it up and take a look.

Pavel
 
Pavel
I finally got it working... I re-created my combo boxes, and the query. I'm still not sure what was wrong. Thanks for all your help.
 
Back
Top