By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,080 Members | 1,817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,080 IT Pros & Developers. It's quick & easy.

Record Source Conflict

P: 26
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
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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.