Form or Query

[Guest]

I am a bit of a rookie, having only used tables in access.
Im trying to figure out whether i should use a form or a query to do
something.
I have information in a table for jobs. The primary key is a job number.
I would like to be able to use a popup box to enter the job number then get
a box come up with all the rest of the job information tied to that number

 

[Albert D. Kallal]

I am a bit of a rookie, having only used tables in access.
Im trying to figure out whether i should use a form or a query to do
something.

As a general rule, using tables direct to enter data is frowned upon. Most
of the reasons for this is that you can't really control much what the user
will do, and it also is harder for the end user to "know" what to do.

Of course, building a form takes some effort also!!

I have information in a table for jobs. The primary key is a job number.
I would like to be able to use a popup box to enter the job number then
get
a box come up with all the rest of the job information tied to that number

If you build a form (in fact, you can use the wizard to build the form), you
can then use the combo box (and wizard) to build a combo box in which you
type in a the job number, then the form will display the data for that job
number.

give the above a try....

 

[Jeff Boyce]

In addition to the reasons Albert offers, using a table for data entry means
YOU don't have much control over the data entry process either.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/