Record Source Conflict

[kjworm]

Greetings all,

I have a main form that does not have a record source. On that main form is a combobox that looks up values from the main table and is based off of a stored query. I also have a subform on the main form that is based on a different stored query. If a user picks an item from the dropdown, then manipulates the data via a popup form, it is then added on the popup close and will appear on the subform. I also have a button to "add new record" if what they are looking for is not contained in the combobox. When this button is clicked a blank form appears. When this form is opened on its own, the blank record fields are displayed. The button works if I base my main form on the table that I am adding a record to, but then the subform will not appear as it is based on a query that is joining data from several tables. Does anyone know a way around this issue? I tried using the SQL on the subform record source rather than the stored query, but this did not work.

I am using Access '97 on Windows XP.

Any guidance would be appreciated.

[MMcCarthy]

As your question is a little complicated its very difficult to follow. I understand that your subform query is based on a saved query. Can you post the SQL of that query.

Also you say that you manipulate data based on a pop up form after the selection in the drop down. Are you adding a new record or editing an existing one? Can we see the code you are using in the close event of the pop up.

I'm not sure what we need to see as the situation you describe is complicated so you should also include the sql for the query behind the drop down.