eliminate a choice from dropdown list once selected

[Bob Quintal]

I got the date on the main form fixed - and the subform works
for the first date- thanks but now when I go to a new date the
subform for the new date shows all of the jobs already
scheduled - would like the subform to got back to blank (and
reschedule for new day)since need to schedule new jobs and
some of the same jobs for new day.


Thanks so much for still helping,
Barb

The link child fields and link parent fields should control this.
Make sure that the Employee listbox and the txtdate field are in
the parent fields, separated with a comma, and the child fields are
the employee and date columns of the subform.

 

[babs]

I got the date on the main form fixed - and the subform works for the first
date- thanks but now when I go to a new date the subform for the new date
shows all of the jobs already scheduled - would like the subform to got back
to blank (and reschedule for new day)since need to schedule new jobs and some
of the same jobs for new day.


Thanks so much for still helping,
Barb

 

[babs]

When I tie the two forms together with the list and combobox as the
masterfield and the subform controls as the child fields. I get ONR record
only visible - the most recent one added on the subform???

any ideas?????

thanks again!!!
Barb

 

[babs]

wondering if I could keep the main and subform still unlinked - still see all
records on subform but when move to NEW record(=new date) only show records
in subform that date in main form = dateAssigne in subform - not sure what
and where to tie this idea of the code to and what code to put in???

thanks again

 

[babs]

Bob,

I got it with putting only the date as the master, child field-makes sense
now. Eventually would like to do total hours assigned to each employee per
day - not sure best place to do this- each job they are assigned has est.
duration - would like to total that up per person in subform and somehow mark
them as not able to assign any more jobs to them???

any ideas?
thanks,
barb

 

[Bob Quintal]

Tried posting this as new problem but don't seem to understand
that the mainform has unbound control combobox

Below is the code I put in and there is an erro

Put where?
What is the text of the error message.

Provide the following data that you will find in the properties
box
form name
subform name
subform source object
cbojoblocautonum recordsource.

Me![Job] = Forms!frmljncCleaning!cbojoblocautonum.Column(1)

I am trying to automatically fill in the job(number) in the
subform based off of what is selected in the combo box of the
main form - the job number is the second field in the combo
box.

I am sure sytax is wrong somewhere - just not sure where??

Thanks,
Barb

The link child fields and link parent fields should control
this. Make sure that the Employee listbox and the txtdate
field are in the parent fields, separated with a comma, and
the child fields are the employee and date columns of the
subform.

 

[babs]

Tried posting this as new problem but don't seem to understand that the
mainform has unbound control combobox

Below is the code I put in and there is an erro

Me![Job] = Forms!frmljncCleaning!cbojoblocautonum.Column(1)

I am trying to automatically fill in the job(number) in the subform based
off of what is selected in the combo box of the main form - the job number is
the second field in the combo box.

I am sure sytax is wrong somewhere - just not sure where??

Thanks,
Barb

 

[babs]

The error I am getting is Runtime error 2465
Access can't fin field 'job' refered to in your expression

Put where?

I am trying to automatically fill in the job(number) in the
subform based off of what is selected in the cbojoblocautonum combo box of
the
main form - the job number is the second field in the combo
box.


form name Main form name is frmljncCleaning

subform name - qrycleaninglPersonnel
subform source object(not sure really what that means) - think object name on subform that trying to automatically input- it is JOB
cbojoblocautonum recordsource(on Mainform) - tbljobsatlocnew

Thanks for still helping,
Barb

Tried posting this as new problem but don't seem to understand
that the mainform has unbound control combobox

Below is the code I put in and there is an erro

What is the text of the error message.

Provide the following data that you will find in the properties
box
form name
subform name
subform source object
cbojoblocautonum recordsource.

Me![Job] = Forms!frmljncCleaning!cbojoblocautonum.Column(1)

I am trying to automatically fill in the job(number) in the
subform based off of what is selected in the combo box of the
main form - the job number is the second field in the combo
box.

I am sure sytax is wrong somewhere - just not sure where??

Thanks,
Barb

in
I got the date on the main form fixed - and the subform
works for the first date- thanks but now when I go to a new
date the subform for the new date shows all of the jobs
already scheduled - would like the subform to got back to
blank (and reschedule for new day)since need to schedule
new jobs and some of the same jobs for new day.


Thanks so much for still helping,
Barb

The link child fields and link parent fields should control
this. Make sure that the Employee listbox and the txtdate
field are in the parent fields, separated with a comma, and
the child fields are the employee and date columns of the
subform.

 

[Bob Quintal]

The error I am getting is Runtime error 2465
Access can't fin field 'job' refered to in your expression


I am trying to automatically fill in the job(number) in the
subform based off of what is selected in the cbojoblocautonum
combo box of
the
main form - the job number is the second field in the combo
box.

Where is the code that gives the error? specifically what event
in what form?

form name Main form name is frmljncCleaning

Open frmljncCleaning in design view. there should be a big
properties menu, it will say FORM on it and have several tabls
named format, data, event other and all on it.
If it is not visible, click once on the properties menu in the
toolbar. It's the one with a finger pointing to a list.

click once on the subform. The properties box will change its
heading to subform/subreport: somename
that name might be qrycleaninglPersonnel. Tell me that name

click the data tab of this panel.
the first three entries are
1) Source object: I need to know that.
2) link child fields:
3) link parent fields:

think object name on subform that trying to automatically
input- it is JOB cbojoblocautonum recordsource(on Mainform) -
tbljobsatlocnew

Thanks for still helping,
Barb

Tried posting this as new problem but don't seem to
understand that the mainform has unbound control combobox

Below is the code I put in and there is an erro

What is the text of the error message.

Provide the following data that you will find in the
properties box
form name
subform name
subform source object
cbojoblocautonum recordsource.

Me![Job] = Forms!frmljncCleaning!cbojoblocautonum.Column(1)

I am trying to automatically fill in the job(number) in the
subform based off of what is selected in the combo box of
the main form - the job number is the second field in the
combo box.

I am sure sytax is wrong somewhere - just not sure where??

Thanks,
Barb

:

=?Utf-8?B?YmFicw==?= <[email protected]>
wrote in

I got the date on the main form fixed - and the subform
works for the first date- thanks but now when I go to a
new date the subform for the new date shows all of the
jobs already scheduled - would like the subform to got
back to blank (and reschedule for new day)since need to
schedule new jobs and some of the same jobs for new day.


Thanks so much for still helping,
Barb

The link child fields and link parent fields should
control this. Make sure that the Employee listbox and the
txtdate field are in the parent fields, separated with a
comma, and the child fields are the employee and date
columns of the subform.

 

[Diane-Maplewood]

Hello,
I've just fiinished reading through your postings. I cannot help you, but
wondering if you can help me. Did you ever get your form to work? I have a
need for a similar form (although for a different task).

If you did resolve the issues with your form, please let me know how you set
it up.