How to populate a field on a continuous form

[ahall]

Hello everyone. My first post here but bear with me as I only started using Access about 4 months ago. I wish I would have found this place back then...



I'm stuck and haven't been able to find an answer via google search (my normal avenue) or by searching these forums.

I need to automatically populate a specific field in a continuous form with the results of a query. To illustrate a simplified version of what I am trying to do, let's assume that I have a query that returns the following results:

qry_Items (Item Class = 3)
Item ID Item Class Item Name
------- ---------- --------------
1 . . . 3 . . . . .US Dollars
2 . . . 3 . . . . .US Halves
3 . . . 3 . . . . .US Quarters
4 . . . 3 . . . . .US Nickels
5 . . . 3 . . . . .US Pennies



Let's say that I also have a table which contains the following information:

tbl_Transactions
Trans ID Item ID Amount
-------- ------- -------------
xxxxxxxx xxxxxxx xxxxxxxxxxxxx



What I want is to have a continuous form open (with tbl_Transactions as the record source), have it create 5 new records (I already know how to count the records in a query) and enter each of the [Item ID] results from qry_Items into the [Item ID] fields of the 5 new records.

I'm trying to hack my way through it in VB but haven't had any success so far. Any help here would be greatly appreciated. Thank you in advance and please let me know if my explanation wasn't clear enough.

[ahall]

So I've worked on this thing for hours and I finally resort to posting my question as searches had lead me to nothing. Ten minutes after I post my issue, I discover my solution. It must have just helped to simplify the problem for my post.

Here's the answer in case anyone else has the same issue:

Just build another query editing the join properties between qry_Items![Item ID] and tbl_Transactions![Item ID] so that the query includes ALL of the records from qry_Items and only those from tbl_Transactions that match. Build the continuous form off of the new query and voila! Just throw another field (we'll call it [Transfer ID]) into the mix and you've got an automatically populated continuous form.

Now to figure out how to mark this post SOLVED...

Thanks for the Forums! I'll definitely be hanging around - if not for answers, for good luck and maybe someday I'll be advanced enough with Access to help someone else out.

[Matrix]

Welcome aboard and thanks for posting back. I hope you enjoy your stay here.

Mark thread as solved.