Hi achett,

When creating a form using the wizard process you are prompted to select the
table or query (the record source) that the form is based on. The form is
then linked to the table or query and so the data entered into the form is
actually being entered into the table. The form itself doesn't hold data, it
merely presents the data from the table or query that it is linked to. The
changes are automatically saved when moving to a different record.

If you don't have the required fields in the table or query that is the
form's record source then you have nowhere to store the data that you enter
via the form.

However, looking up a record using the combo box (creating using the wizard
to 'find a record on my form...' I would guess) will open the record with
that JobName. If you have the same JobName many times then the combo box will
have the jobname repeated and, without further information when selecting in
the comb box, it will not be easy to select the correct jobname record.

If JobNumber is unique then it would be possible to use that as aprimary key
but you would be better served to create a field in the table, perhaps called
JobID, with data type AutoNumber. Recreatint the lookup combo box using the
Wizard could then find the record based on its JobID but, if you follow the
wizard, the user will see the JobName. I would suggest adding the JobNumber
to the lookup combo box also so that the user can see which JobName is
required (e.g. if it's blank that may be the one that's required.

Hope this help

accessjunky

"achett" wrote:

I have posted my question 3 times already, and I haven't gotten any help..If
you come across my questions please help.
I have a Table with the following fields JobName, Job Title,
Printer, Lines..etc. I would like to enter and update this table via a
Form.On the Form I have a combo Box(JobName), which helps me to retrieve a
record from the table. Once thats done, I want to assign a number to that
record (I might use the same JobName more than Once with a different Job
number). I do not have the Job Number included in the Table and I do not have
any Primary keys. After I make the appropriate changes to the record I want
that record to be saved to the Table.

Thanks a lot..