Trouble with subform updating in 2007 - works in 2013

[vclink]

I have a travel database that I need to be able to use in Access 2007. One of the forms has the information for an individual specific to a trip. I have two subforms to add and list the flights and hotels the individual will use on this specific trip. The select for the dropdowns in each of the subforms is a combo box and includes a "where tripid = forms!mainform.tripid". This works without issue in Access 2013 but as soon as I copy or import and then open in 2007 my dropdowns in the subforms don't work. The entries already made list the correct flights, times, etc. but the field that is the dropdown is blank and when I click the dropdown I get no options to select (should be flights or hotels with that tripid). The users for this system only have 2007 available to them currently so I need to come up with a fix. Do I need to start from scratch on this mainform and subforms in 2007? (Or just beg to have them updated to 2013! )

[rpeare]

sounds like a refresh and/or requery issue. if this is a bound form are you refreshing each of the combo boxes when you navigate to a new record or change the tripID on the main form? Might be a problem with a table not existing, or having the correct information in your 2007 version as well, like your table may have a link to a table where there's nothing in it therefore it can't bring up the description you're after. Have you tried opening the 2007 version of your front end in 2013 to see if the behavior persists?

[vclink]

I think that may be the issue for 2007 - just need to figure out what I need to do with the event to get the right stuff to show up. Tables (and all database items) are the same in the 2007 as the 2013. I can open the same database in 2007 and it doesn't work (doesn't show the flight info if I change records to one with a different tripid) - but open it in 2013 and it does.

[rpeare]

Any chance you could upload a sample database that has enough fake data in it to mimic this problem.