Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

creating form to search ser number and enter another number

hello,
if you open database- a form opens:
enter 1111 for serial number
The form fills in below-
Now I need to enter service no [ any number]-
after i enter any number- i need to create report with just that record-
I am thinking there is a better way to approach this then I am - can you help?
also my report is not working.

tjhis form, is only meant to search serial number and enter service no and create report.

thank you
number.mdb
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Removed code in txtOne KeyDown event, added code to txtOne AfterUpdate event.

Works now ...

mx
Avatar of davetough
davetough

ASKER

great! thanks DatabaseMX