Need Form and TextBox Help

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Klatuu,

Since I posted the last response; I was thinking I should go back and
reset my form...So I did a test of it and came up with this that may
solve the whole problem. Maybe...
When you add a combo box and the wizard pops up it asks where do you
want to store the data? Can you store that data in 2 tables at once?
Hmmmm....

Thanks,

H
wrote:
Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans

Klatuu,

I will work on tonight...BTY where are you at/live?
Hans

Klatuu wrote:
Actually, if you are going to do this from the form, it would be easier and
faster to use an action query. I can show you some sample code, but I need to
know if you will be adding records to ResumeDates or updating existing
records. It is late, so I can't get to it until tomorrow.

" wrote:

Ok...maybe I can be on the same page with you...bear with me.
I may have mislead you earlier...The date and resume data would reside
in a different table(ResumesDates) and not with all the other
data(ISSOpenPosition). If I understand normalizations etc...this is why
I did it this way. So, the ISSOpenPosition would be done via recordset
processing, but not the ResumesDates, which is where I have my
problem...
Does this help??

Thanks,

H

Klatuu wrote:
No. Recordset processing is like the old traditional way to deal with data.
You open a recordset based on a table or query, then move throught it either
using or updating the data in the record or adding or deleting records
programmatically.

I May not be understanding you, but what I thought you originally said was
that you are updating a table that is not the table your form is based on.
If this is correct, how are you doing it?

" wrote:

Now I am going to REALLY show my ignorance of Access...What is
recordset processing?
I set up the Form thru the form wizard and selected the table that I
wanted, i.e. ISSOpenPosition...Is this recordset processing??


Klatuu wrote:
Good info, but what I was really after, is the method you are using to update
the other table, recordset processing? an action query?, or, perhaps based on
your most recent post, passing the info to another form.

What I am thinking is that you can include the value of the combo in
whatever you are using to pass the data.

" wrote:

Hey Klatuu...
The form HR-ISS Open Position is based on the TBLISSOpenPositionTable
All of the "other information" is set to that table by the control
source...is this what you are asking? Still real new here...

Take a step back and fill in some missing details....
The main table ISSOpenPosition controls the following combo & text
boxes on form HR-ISS Open Position either directly or the underlying
query and records the data in the ISSOpenPosition Table
StoreVacancies (CBO) (FK in table) - recorded in ISS table
Tracking Number (TXT) (PK in table) - recorded in ISS table
DMName (DLookup)
RMName (DLookup)
RSQ Hours (DLookup)
RecruitStart (TXT) ------- recorded in ISS table
RecruitEnd (TXT) ---------recorded in ISS table
BackgroundStart (TXT) -recorded in ISS table
BackgroundEnd (TXT) --recorded in ISS table
StartDate(TXT) - recorded in ISS table
(When I get ready to run the report later I can query all of these to
produce my report...)

What I cannot figure out what/how to do is this:
HR needs to know on any given store how many times they sent a resume
out and on what date...
So, I came up with another table TBLResumesSent with the following
columns
PK (auto), StoreNumber, Date, ResumesSent

I need the StoreVacancies(CBO) data to be "passed" over to the
ResumesSent table along with date and resumes sent.. "passed" over
meaning the user does not have to re-type or lookup the store number on
the same form. If I can get this accomplished then when I run my report
query I would include the TBLResumesSent to get all of my results.

Does any of this make sense to you? And is this the way I should do it?
My reason on an additional table is that the store number could be
duplicated SEVERAL times! I have one instance that has one over 25
times...and I could not put this in an existing table or can I???

Once again I thank you!

Hans








Klatuu wrote:
How are you updating the other table with the date and resume info?

" wrote:

I am new to the Access game and run across issues that I just do not
have a clue how to do...

On my form I have a Combo Box where the user selects a store number and

all the pertinent information in the textboxes fill in...this is for
viewing purposes only. I have 4 text boxes where the user will input
information for new data storage. This is running very smoothly. My
problem is this; I need to input into another table the store number
from the combo box along with the date selected and # of resumes sent
out. The date and resumes I can do, I just DO NOT know how to pass the
store number from one table thru the combo box into another table on
the fly...


Help is needed on this one!


Hans