Combobox doesn't show right values

[jessy]

Hello There,

i have a form where i want to show only the valid combobox entries for a record.

If i scroll down my form, most values are shown right. But some doesn't. After i requery the field (not the form) the values are shown right.

I don't know what is the problem and even if it is possible. In different google entries they say: make a custom function to retrieve the column(0) value or reference it by a textbox which i did.

thank you

 

[June7]

Review https://stackoverflow.com/questions...ous-form-the-second-combo-doesnt-show-its-val

 

[jessy]

thank you for the fast hint

So, as i understand, i have to "fake" the appearance with a normal textbox control which overlays the combobox and include the field in the source for the form. Sorry, english is not my native language and the solution-text is difficult to read (and understand) for me.

 

[jessy]

Unfortunately if i left join the neccessary table, to include the field, it is no more possible to add new records. Can i solve this somehow.

I even would restructure the gui to keep the possiblity to add new records.

 

[CJ_London]

what you are talking about sounds like what is frequently referred to as cascading combo's - although in your case the first combo is a textbox. However this does not impact the way your 2nd combo would work.

See this link

enabling cascading comboboxes in datasheet or continuous form

Having been asked about this recently, I reinvented some code I developed to work with datasheets and which also works with continuous and single forms. The attachment was developed in 2010 but saved as 2003. The db demonstrated two techniques for using cascading comboboxes. Technique 1 is...

www.access-programmers.co.uk

Basically you need code to add criteria to the combo rowsource when it has the focus and to remove the criteria when it loses it.

 

[arnelgp]

what kind of form do you have Single, Datasheet or Continuous?
can you upload a sample of your form?

 

[jessy]

@CJ_London:
Thank you for the example db. I will look into it.

@arnelgp
It is a continous form. I will reduce the database and upload it. but that will take a little time to extract all private data.

 

[arnelgp]

here is a demo.
see main_table form.
on design view there is a textbox "overlaying" (bring to Front) on top of the last combobox (the combo position is Sent to back).