Simple Form To Enter Data

[WCWoodie]

I use MS Access mainly for performing queries -- I am new to forms.

I am trying to create a very simple form that will enable input to an inventory table. It sounds easy, but I haven't been able to figure it out in the help manual!

There are several fields in the table, but my form will only have three fields:
Ticket#, Part#, and Quantity ("Ticket#" is a primary key)

I want to allow a user to enter any ticket #, and then have the form autmatically jump to the record for that ticket. The Part# will display, and the user can enter the quantity for that ticket. The problem is that when a ticket number is entered (say 1023), all that happens is the value of "ticket" is changed for the current record. Instead, I want the form to jump to the record that contains ticket # 1023 so the quantity value can be changed.

I hope this makes sense, and that someone can tell me how to do this. Thanks!!

 

[PHV]

Why not simply follow the wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[WCWoodie]

The problem is the Wizard only gives me choices to make forms as:
- columnar
- tabular
- datasheet
- justified
- pivot table
- pivot chart

I want to make a form that just looks like:

----------------------
Ticket# ________

Part# _______

Qty: ________
----------------------

After each record is update, a new ticket# can be entered without searching though a long column of ticket#'s.

 

[Betsvigi9]

Try using the justified form wizard and then amend it so that it looks the way you want it to.