Auto fill

[Krash878]

This one is a little weird and you may agree.

I would like to build a form that lets me look at my table at info that is already there. On that form I would like to have a command button that would be called OCB. This button would write to two feilds when clicked. The two feilds are DateOCB and OCBFee. The data would be Date() for DateOCB and $20.00 for OCBFee. It would populate strait to the table and not show on the Form.

Can this be done and if it can be done how would I come about doing this.

Thanks
Kenny

 

[braindead2]

the easiest way would be to include those fields on your form but set the visible property to false
then on the buttons event set the fields value to what ever you desire.
example!

Private Sub Command1_Click()
me.DateOCB = Date()
me.OCBFee = "20.00"
end sub

 

[TTThio]

One way is still to have those 2 fields in the form with visible property set to No. Then do fill-up in the cmdClick. As the two fields have the table as the control source, value will be updated automatically.