469,086 Members | 1,227 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Creating Records Based on Selecting Specific Results from a Query


I need some help/advise about how to tackle an Access problem. Right now, it's kind of a big idea and I would really appreciate any input about how to do it properly.

I essentially want to create a form that queries various records. I then want a user to be able to select various and specific records from the results of the query to create records in another table. I want to have other unbound controls on the form header that will contain information that will be added to the created records.

Anyone have a good idea about how to do this? Please?


Oct 6 '09 #1
2 1423
1,287 Expert 1GB
You can either put the results of your query in a multi-select list box, or a continuous subform with a checkbox field to select the records. Then on a button press, loop through the selected records and run sql insert commands. The data from the unbound fields in your form can be inserted into the sql string.
Oct 6 '09 #2
32,159 Expert Mod 16PB
The first suggestion will work.

Be careful of the second. Remember that there would need to be an appropriate place to store the CheckBox results. As this is transitory, process related, data there is nowhere easy to do this (if it's to be done safely within a potentially multi-user environment). A table would be required which is either in an FE database where each operator has their own copy, or a table would be needed which contained a field to separate out data for different operators. All quite messy as you will see.

Unless you're confident of managing all that I would seriously consider the ListBox option with Multi-Select enabled.
Oct 6 '09 #3

Post your reply

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

Similar topics

2 posts views Thread by Iain Miller | last post: by
reply views Thread by allyn44 | last post: by
1 post views Thread by Trent | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.