472,145 Members | 1,578 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Record Source Conflict

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.
Nov 9 '07 #1
1 1508
14,534 Expert Mod 8TB
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.
Nov 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Owen Jenkins | last post: by
5 posts views Thread by payffl | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.