Write Value to Form Field

[raweber]

Almost feel like I'm cheating coming here to ask rather than doing all the research and homework myself...

Anyway, I have a button that calculates a value, and I want to then populate a field on my form with that value. I've successfully calculated the value (and have a msgbox to confirm it), but I'm not sure where to go to populate the field.

I know how to write and entire record into a table, but I don't want to go to all that trouble if I don't have to.

The table linked to the form is StudyData, the form is frmDataEntry, the vaule is NewWONumber and the field is WorkOrderNumber.

Any help appreciated, Rob

 

[RainLover]

Try putting the calculation directly into thr Form Field.

PS The word Field is incorrect. It is actually a "Control" Fields are found in Tables.

 

[raweber]

Unfortunately, not every record is going to need a Work Order. In fact, the majority will have a null here. That's why I have a button to fill it in (the automation is because the tech will likely not know what the next work order number is).

Thanks for the tip on the nomenclature.

Rob

 

[RainLover]

Use the OnClick Event to write the value to the required Text Box.

EG

me.TxtBox = 1+2


If this doesn't work then I need more information.

What have you got so far?