BLANK FORM / QUERY

[tom]

My database is pretty basic with tables, forms, queries etc. I'd like to
display a form that allows me to type in a figure in the first field and the
rest of the fields will populate automatically. I'm not sure how to create a
query where the field awaits input. Thanks in advance.

 

[Arvin Meyer [MVP]]

In the query's criteria box, use square brackets:

[Enter a value]

or from a form:

[Forms]![FormName]![txBoxName]

in the first case, you will be prompted. In the second, you will only be
prompted if the form isn't open.

 

[BruceM]

You can use the Criteria row in a query to request a parameter. For
instance, for items that cost more than $100 the criteria could be:

100

To allow for a variable amount you could have:

[Enter Minimum Amount]

This will present the user with the prompt: Enter Minimum Amount
However, if you are talking about entering, say, a company name and having
the rest of the company information appear (that is, go to the selected
record), that is another matter. It's quite possible, but without more
details it is difficult to make a specific suggestion.

 

[tom]

Thanks Arvin. I dont understand the form bit. Where do I type in
[Forms]![FormName]![txBoxName] ?

--
TomMurray

In the query's criteria box, use square brackets:

[Enter a value]

or from a form:

[Forms]![FormName]![txBoxName]

in the first case, you will be prompted. In the second, you will only be
prompted if the form isn't open.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

My database is pretty basic with tables, forms, queries etc. I'd like to
display a form that allows me to type in a figure in the first field and
the
rest of the fields will populate automatically. I'm not sure how to
create a
query where the field awaits input. Thanks in advance.

 

[Arvin Meyer [MVP]]

In the query's criteria box for the field you want to select the criteria
from.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Thanks Arvin. I dont understand the form bit. Where do I type in
[Forms]![FormName]![txBoxName] ?

--
TomMurray

In the query's criteria box, use square brackets:

[Enter a value]

or from a form:

[Forms]![FormName]![txBoxName]

in the first case, you will be prompted. In the second, you will only be
prompted if the form isn't open.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

My database is pretty basic with tables, forms, queries etc. I'd like
to
display a form that allows me to type in a figure in the first field
and
the
rest of the fields will populate automatically. I'm not sure how to
create a
query where the field awaits input. Thanks in advance.