Create a form whose sole purpose is to change the default value of the batch
number on the payment entry form.
Add a text box (txt_NewBatchNumber) to enter in the new batch number and a
button with a caption like "Update Batch Number Default".
In the click event for the button, put the following code:
DoCmd.OpenForm "frm_PaymentEntry", acDesign
Forms!frm_PaymentEntry!txt_BatchNumber.DefaultValue =
Me.txt_NewBatchNumber
DoCmd.Close acForm, "frm_PaymentEntry", acSaveYes
The above code opens the payment entry form in Design mode, changes the
default value of the Batch Number text box, and closes and saves the form
without prompting to save changes.
HTH,
Toby
----- Original Message -----
From: "morrisaccesshelp" <[EMAIL PROTECTED]>
To: <AccessDevelopers@yahoogroups.com>
Sent: Wednesday, November 30, 2005 1:32 PM
Subject: [AccessDevelopers] batch
> I have an enduser who wishes to input customer payments into an access
> database. They need to ability to assign a batch number to the
> payments. Once all payments have been entered they would print a
> report based on the batch number. My problem is I cannot figure out
> how to set the system up so they can easily change the batch number. I
> know they can go into the field properties on the form and set the
> default but I would rather have a routine that makes it user friendly.
>
> Can anyone help me out?
>
> Thank you!!!
>
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
