Newbie - pretty basic questions.

[AmySelfTaught]

I am setting up a form in which there will be 3 fields: WO #, Part # and
Serial #.

Question 1: How can I have someone enter the WO# once and carry it through
the rest of their entries? The WO# will be the same for many records that
are being entered. I could have 5 records or 500 records with the same WO#.

Question 2: The Part # will be one of about 15 possible entries. I want to
have two options for entry, a drop-down menu AND and auto-fill option (a
person starts to type the Part # and Access recognizes it after a certian
number of characters and fills the rest). How can I do this? Depending on
who is doing the data entry, they may choose which way they want to do it.

That should do it. Thank you!

 

[Dirk Goldgar]

I am setting up a form in which there will be 3 fields: WO #, Part # and
Serial #.

Question 1: How can I have someone enter the WO# once and carry it
through
the rest of their entries? The WO# will be the same for many records that
are being entered. I could have 5 records or 500 records with the same
WO#.

Normally you would have three tables involved in this functionality: a
WorkOrders table (guessing that work orders are what we're talking about),
with one record per work order (primary key [WO#]; a Parts table, with one
record per part (primary key [Part#]; and a WorkOrderParts table (or
something like that), with one record for each part used in each work order.
The WorkOrderParts table would have the records being added or edited by the
form you describe.

I'd recommend using a main-form/subform arrangement, with the main form
based on the WorkOrders table and the subform based on the WorkOrderParts
table, and the subform linked to the main form by the [WO#] field. That
way, the WO# of the current main-form record will always be stamped
automatically in each record you add via the subform.

Question 2: The Part # will be one of about 15 possible entries. I want
to
have two options for entry, a drop-down menu AND and auto-fill option (a
person starts to type the Part # and Access recognizes it after a certian
number of characters and fills the rest). How can I do this? Depending
on
who is doing the data entry, they may choose which way they want to do it.

If you use a combo box based on the Parts table to enter or select this
value, and you set the combo box's AutoExpand property to Yes, then this
will happen automatically.

 

[Al Campagna]

Amy,
Don't use # in your field names. It's used in date functions, and
could cause trouble.
Try WONo, or PartNo, or SerialNo instead.

Using PartNo as an example...
1. Use the AfterUpdate event of PartNo to set PartNo's
Default Value to what you just entered.

Private Sub PartNo_AfterUpdate()
PartNo.DefaultValue = "'" & [PartNo] & "'"
End Sub

(Expanded to show quotes... " ' " & [PartNo] & " ' ")

That value will now appear on every new record you create... unitl
.... you change it to some new value. Then that value will appear
on all new records... etc.. etc..

2. A normal combobox, with it's Auto Expand property set to Yes, will do
as you indicated.
As the user types, the combo will attempt to find a match from your combo
listing.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Gina Whipp]

Amy,

I think you should tell us about your table structure because there should
be a table for Work Orders, let's say tblWorkOrders and a table for Parts,
tblParts which should include the Serial ID for those Parts but I may not be
understanding. Then there should be a table where you join Parts to Work
Orders... like which Part is needed for each Work Order...
tblWorkOrderParts.

But I don't know your table structure and I am guessing you want to track
Work Orders and Parts but if it's ore then that let us know.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm