How do you have a value put into the Value property of a control on the form
via VBA code?
Situation:
User determine what to do with the record after the fields been filled as
opposed to Access wanting to know which edit mode to go into prior to
filling in the fields. This is the real stickler as I'm attempting at
keeping the database as the same feel as JDE to the extent reasonably
possible.
Question: In order to set the value or text on these controls with the
"RecordSource" on the form set to "", do I need to *UNBIND* the controls,
set the value of the control, then *BIND* the controls again for this to
work?
Re: OnClick event not firing ... Does anyone have ...controls, sometimes the event linked to that control gets "lost" somehow. ... I exit the VBA code and return to form design view. ... code is not disconnected from the control - it's just not firing.... (comp.databases.ms-access)
Re: Combo box not working ... > I have to use a VBA code on a project. ... From tbl:CANFY2003ORDER BY txtNEWCAN#;... > End Sub... name (the control is NEW_CAN, but the code if for a control named ... (microsoft.public.access.forms)
Re: Creating a directory ... you can use the Control Source of a text box. ...Allen Browne - Microsoft MVP. ... In another report I use the On Format event for the Detail Section to trigger an option to add a border to a field's value "if IsNull" is true or no border if false. ... I tried something similar but there were no events to trigger the VBA code I want to use which would open the second table and find a record/name. ... (microsoft.public.access.reports)
Re: Designing a Form using VBA code ONLY ... I have a lot of experience with VBA code in MS Word and want to ... allow much more control at the expense of MUCH more work. ... but it will be a ton of busy work, be much harder to control, and, if you ... Read about Formatting, Data, Events for the forms and text boxes.... (microsoft.public.access.formscoding)
Re: Re-displaying a blank data entry form ... also created some VBA code to check and make sure that all the values are ... If it's a bound form, add a line of code to tell the form to go to a new record: ... If it's an unbound form, you'll have to go through the form's controls and set each editable control to Null. ... (microsoft.public.access.formscoding)
