Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Two form questions

Status
Not open for further replies.

RAClarke

Instructor
Sep 3, 2001
51
GB
I wonder if someone could be kind enough to explain how I achieve the following on a form.

1) If I enter data say into the 1st field on my form, how can I make it jump to the 3rd field and leave the 2nd blank?

2) If I entered numeric data into the 2nd field, how can I place a tick in the 4th field tick box automatically?

An assistance would be greatly appreciated!!!

Thanks
 
Hi

In afterupdate event of field 1 put field3.setfocus

In after update event of field 2 put:

if IsNumeric(field2) Then
field4 = true
End if Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top