469,313 Members | 2,261 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Record Source Conflict

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
1 1411
MMcCarthy
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 zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.