Update combo box when scroling through records.

Hi

I have a a form for engineers to input their weekly jobs. This has 2 field, the engineers name and the weekending Date. The weekend Date is a lookup from a Weekending Date Table.

The Subform has a Combo box that looks up all the jobs that the engineer has completed, which comes from a query, and uses a Dlookup to populate the subform.

My problem:

I am trying to GET the Combo to display only records for that weekending on the main form, ie. Between [Forms]![Worksheet]![WeekendingDate] and [Forms]![Worksheet]![Weekending Date] -7

The Main Form is filtered to only display the current and previous weekendings. The combo on the subform seems to pull from the first weekending, but does not update when I go to the next weekending.

Where am I going wrong?
SparkyPAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this


EE22022011.mdb
0
 
MINDSUPERBCommented:
Your combo box might need a requery action.

Me.Combo.requery

Sincerely,

Ed
0
 
SparkyPAuthor Commented:


Thanks ED

I have tried Requery in various actions, both on the combo box and the forms, but without success.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
MINDSUPERBCommented:
Can you post the Row Source of your combo box?

If you can post a sample db, it would be better.

Ed
0
 
Rey Obrero (Capricorn1)Commented:
did you try to requery the combo box in the Current event of the form [Worksheet] ?
0
 
MINDSUPERBCommented:
Cap in a rescue. How are you doin' Cap? Wish you well.

Ed
0
 
SparkyPAuthor Commented:
Capricorn

Tried the Current Event but seem to get some form of loop, the screen flashs on the same record for several second.

I am in thethrows of reducing the database to send.

0
 
SparkyPAuthor Commented:
Please find attached sample of database. The form in question is called WRS. Many Thanks
EE22022011.mdb
0
 
Rey Obrero (Capricorn1)Commented:
what are the names of the combo boxes? in the main form and in the subform?
0
 
SparkyPAuthor Commented:
Hours ID is the Combo Box that gives the list of Jobs. Tis is the area in the * when the form is open.
0
 
Rey Obrero (Capricorn1)Commented:
your combo box rowsource have a criteria on the field [Job Date]

Between [Forms]![WRS]![Weekending Date]-7 And [Forms]![WRS]![Weekending Date]+14

are you aware of this?
0
 
SparkyPAuthor Commented:
EE is worth every penny (dollar, rupee etc)!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.