Autofill Batchdate

[Bob87476]

I have following Tables/Fields
1. tabDonations
ID
DonorID
BDateID
Amount

2. tabDonors
ID
Name

3. tabBatchDate
ID
Date

Process
Donations are entered in Batches by Date

I am creating a Donation Entry Form to perform following
STEPS
1. Select a Batch date already in the BatchDate table

2. Enter several donations with the date selected above.


PROBLEM
How do I Autofill the Batchdate for each new donation?

Thanks in advance for any assistance

Bob

 

[highandwild]

I would have:

A 'Batches' form with a means to locate a batch record. This form could have a subform or listbox displaying all of the donations for the batch.

A Donations button to load a popup form to enter new donations for that batch into the Donations table. This form takes the batch ID from the ID on the Batches form. A submit button saves the record and closes form.

You may need to create a new doner record when entering a donation so another popup form to do this could be used with buttons to load the form on either the Batches or Donations forms or both.

 

[Bob87476]

I would have:

A Donations button to load a popup form to enter new donations for that batch into the Donations table. This form takes the batch ID from the ID on the Batches form. A submit button saves the record and closes form.

I like your ideas Highandwild

My first problem is how to "take the batch ID from the ID on the Batches form"
And auto fill the donation record with that batch ID

Bob

 

[highandwild]

[FONT=&quot]Either pass the ID in the OpenArgs of the form when loading the Donations form

e.g. DoCmd.OpenForm "frm_EnterDonation", , , , , acDialog, Me.txtID

where txtID is the control on the Batches form containing the Batch ID.

and then assigning this to the textbox on the Donations form in the Open event of the Donations form.

e.g. Me.BatchId = Me.OpenArgs

OR

In the Donations form Open event make reference directly to the textbox on the Batches form.

e.g. Me.txtBatchId = Forms![frm_Batches]![txtBatchId]

[/FONT]

 

[Bob87476]

Thanks
I will try that
Bob

 

[Bob87476]

I chose the second option

[FONT=&quot]

OR

In the Donations form Open event make reference directly to the textbox on the Batches form.

e.g. Me.txtBatchId = Forms![frm_Batches]![txtBatchId]

[/FONT]

But the procedure couldnt find the value of the BatchID unless I have the frm_batches open in a separate window.
The contol that had the batch date I wanted is child32
What is the syntax to point it to the data in child32?

Thanks
Bob

 

[redalert]

The idea is that the calling form is kept open and the called form just sits on top.

Both forms are Popup, Modal and Moveable so that they can be put side by side or overlapping as required,

If this does not work then use the option whereby the ID value is passed using the OpenArgs option.

 

[Bob87476]

Makes sense
Thanks

 

[Bob87476]

Thanks for help

I started with a blank form for Donation Management and then added buttons to add new donations etc and also a sub form (child0) which shows all donations (based on a query)

Working good so far except I would like to refresh the list of donations after I enter a new donation as confirmation my entry was correct.

Any ideas?

Thanks

 

[redalert]

If the donations are in a subform use the following but substitute references where necessary.

Forms![Orders]![Order details].Requery