Form to select a Record

[Guest]

When I open my form, It opens to a form [frm_JobName]. [frm_JobName]
consists of 1 combo box [JobNameSelect].
[JobNameSelect] is a list of all the Job Names in my table [tbl_QuoteLog]

When I open [frm_JobName] I want to begin typing a potentially new Job Name.
If the Job Name that I am trying to type in is already in use, then I will
select that from [JobNameSelect], and I want my it to pull me into another
form [frm_QuoteLog] where I will edit the that current entry.

If the Job Name that I am entering is NOT already in the list
[JobNameSelect] then I want to open [frm_QuoteLog] to a new record.

How do I go about this?

The key is to not allow duplicate Job Names, but I can NOT make Job Names
Primary Key because I already have a Primary Key that I can't get rid of.

Thanks in Advance,
Travis

 

[Rick Brandt]

When I open my form, It opens to a form [frm_JobName]. [frm_JobName]
consists of 1 combo box [JobNameSelect].
[JobNameSelect] is a list of all the Job Names in my table [tbl_QuoteLog]

When I open [frm_JobName] I want to begin typing a potentially new Job Name.
If the Job Name that I am trying to type in is already in use, then I will
select that from [JobNameSelect], and I want my it to pull me into another
form [frm_QuoteLog] where I will edit the that current entry.

If the Job Name that I am entering is NOT already in the list
[JobNameSelect] then I want to open [frm_QuoteLog] to a new record.

How do I go about this?

The key is to not allow duplicate Job Names, but I can NOT make Job Names
Primary Key because I already have a Primary Key that I can't get rid of.

Apply a unique index (indexed - duplicates no)

 

[Stephen at ZennHAUS]

When I open my form, It opens to a form [frm_JobName]. [frm_JobName]
consists of 1 combo box [JobNameSelect].
[JobNameSelect] is a list of all the Job Names in my table [tbl_QuoteLog]

When I open [frm_JobName] I want to begin typing a potentially new Job
Name.
If the Job Name that I am trying to type in is already in use, then I
will
select that from [JobNameSelect], and I want my it to pull me into
another
form [frm_QuoteLog] where I will edit the that current entry.

If the Job Name that I am entering is NOT already in the list
[JobNameSelect] then I want to open [frm_QuoteLog] to a new record.

How do I go about this?

The key is to not allow duplicate Job Names, but I can NOT make Job Names
Primary Key because I already have a Primary Key that I can't get rid of.

Apply a unique index (indexed - duplicates no)

Indexing with no duplicates will work to stop duplicate jobs, but it sounds
like you want to use the same form to choose from a combo box as well as
update the list that feeds the combo box. Where are the NEW jobs being
entered? In [frm_QuoteLog] or do you have another form for creating new
jobs? Assuming you are using frm_QuoteLog, just create 2 buttons using the
button wizard. One button takes you to the selected JobName and the other
is to create a NewRecord.

It's a bit hard to provide definitive answers when the detail of how what
you are doing works is missing.