07-10-11, 09:28 #1Registered User
- Join Date
- Jul 2011
Unanswered: Need help with a field in a form!
I have a form(frmLegalAid), its default view is Continuous Form.
I have a field called Fee Earner in a combox, i need some way of the value in the fee earner combox to automatically be transferred to the new combox when a new record is made.
Is there anyway of doing this?
If you need any more info, please ask!
Thanks in advance for any help!
Last edited by rasghar; 07-10-11 at 09:55.
07-10-11, 12:58 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
I've answered this for you elsewhere, but on the off chance that someone searches this forum for this kind of thing, I'll post it here as well!
In your form, you can use the AfterUpdate event of the control holding your data to set the DefaultValue for the field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each new record.
Private Sub FeeEarner_AfterUpdate() Me.FeeEarner.DefaultValue = """" & Me.FeeEarner.Value & """" End SubHope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007