Passing query parameters from a form

[AbuFarooq]

Hi All...

I am new to database programming. I need a help in designing some forms
and queries.

I designed a query which takes a value entered in a text control box in
a form, and subtractes it from a field in a table. when I run th query
from the query designer window, it prompt me for the value to subtract,
and update the required table perfectly. However, when I try to enter a
value in the text box in the form, and click a button linked to a macro
which runs the query, the query is executed, but the requiered value in
the tabel becomes empty.

I guess the problem might be related to passing the parameter form the
form to the query.

Any advise ?

 

[Michel Walsh]

Hi,


In the query, use the syntax:

FORMS!FormNameHere!ControlNameHere


and run the query when the mentioned form is opened, and whenthe control
name has some validated value in it.


FORMS is a keyword to be typed as it is. Form name and Control name are to
fit the ones in your case.


Hoping it may help,
Vanderghast, Access MVP