Hi,
I want to retain some values in text box but not all, form is bound.Please anyone suggest how to do it.
Hi,
I want to retain some values in text box but not all, form is bound.Please anyone suggest how to do it.
Use the forms BeforeUpdate event to set the Default Value property of the controls that you want to carry forward to the next record
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Can you please explain with example.
1.Form Is Bound
2.Set Required field to Yes
3. I'm attaching file below in that file from Customer to Type of order value should remain same till they enter different line items for one PO Item,so i have to keep these fields with same values such that they need not enter the same values again and again.
In the Forms Before Update event you need one line of code for each value that you wish to carry forward.
Something like:
Me.ControlName.DefaultValue = Me.ControlName
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
The 'something like' Bob is talking about is this:
Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
This syntax is valid for Text, Number, DateTime and Boolean Datatypes.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007