Link to home
Start Free TrialLog in
Avatar of ripsrv10
ripsrv10

asked on

MS Access Query and expression builder

I am trying run a query and in my query one of criteria fields is setup to select data from another form.  So I enter a serial number into a form and then I run the query on event update.  In the query I am using the expression to insert the serial field from the form but I does not work.  My query works because I can hard code the serial number into the field and it returns back data?
ASKER CERTIFIED SOLUTION
Avatar of Chuck Wood
Chuck Wood
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
SOLUTION
Avatar of Helen Feddema
Helen Feddema
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
SOLUTION
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
Avatar of ripsrv10
ripsrv10

ASKER

1