drop-down based on parameter query

[babs]

I have a drop- down list in a suform based on a query that has prompt for 4
dif. sets of dates. basically same set for each month. (approx - 400
records-jobs/month) though i thought I wanted it to prompt not sure if i
should Make tables or append queries??? for 12 dif months. each time i open
and close the form even just to add an hour or 2 to someone shedule I get
reprompted. Is there a better way to set up to populate the drop down with
(current jobs- based on 4 dif beg. end date parameter) what am I missing??

Any ideas on best way to do this.

thanks,
barb

 

[Jeff Boyce]

Barb

"How" depends on "what" ... and I don't have a very clear picture of what
data you are working with, nor the structure you are storing it in.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I have a drop- down list in a suform based on a query that has prompt for 4
dif. sets of dates. basically same set for each month. (approx - 400
records-jobs/month) though i thought I wanted it to prompt not sure if i
should Make tables or append queries??? for 12 dif months. each time i open
and close the form even just to add an hour or 2 to someone shedule I get
reprompted. Is there a better way to set up to populate the drop down with
(current jobs- based on 4 dif beg. end date parameter) what am I missing??

Any ideas on best way to do this.

thanks,
barb

A correct query as the rowsource of the combo should work without any
prompting. What is the Row Source now? Please post the SQL, and indicate what
you mean by "with (current jobs - based on 4 dif..."? We have no way to guess
what you mean by "current jobs".

 

[babs]

SELECT [Jeff JObs Visual - Link].[Job Name], [Jeff JObs Visual - Link].[Job
#]
FROM [Jeff JObs Visual - Link]
ORDER BY [Jeff JObs Visual - Link].[Job Name];

This is the SQL presently that is tied to the job# drop down list. In the
query Jeff Jobs Visual - Link ( actually in the many others that feed into
it) are parameters in the criteria row to prompt for Invoic beg date, Invoice
end date, Material beg date, Material end date, etc - 2 other sets of date (
all this gives the jobs we care about for this month scheduling)

Not sure of best way to grab these jobs on a daily basis to populate the
drop down list - would it make sense to creat a make table for each month and
then run an append query daily to the given months table??? not sure how to
create this job list -

got it in the Jeff JObs Visual - Link Query but not sure how to get those
jobs we care about show up for that week/day of scheduling???

thanks so much for your help,
Barb

 

[John W. Vinson]

SELECT [Jeff JObs Visual - Link].[Job Name], [Jeff JObs Visual - Link].[Job
#]
FROM [Jeff JObs Visual - Link]
ORDER BY [Jeff JObs Visual - Link].[Job Name];

This is the SQL presently that is tied to the job# drop down list. In the
query Jeff Jobs Visual - Link ( actually in the many others that feed into
it) are parameters in the criteria row to prompt for Invoic beg date, Invoice
end date, Material beg date, Material end date, etc - 2 other sets of date (
all this gives the jobs we care about for this month scheduling)

Not sure of best way to grab these jobs on a daily basis to populate the
drop down list - would it make sense to creat a make table for each month and
then run an append query daily to the given months table??? not sure how to
create this job list -

Absolutely NOT. Creating a new table every month - or even appending data
redundantly - is totally the wrong way to go!

Instead base the combo on a Query with criteria selecting those jobs that are
"current". You know far better than I how to identify those jobs. I have no
way to know whtat's in [Jeff JObs Visual - Link] - is there a date field or
anything else that would indicate which ones you "care about"? Your row source
right now is simply selecting everything in the table.