Combo boxes used for criteria

[MarieM via AccessMonster.com]

My database has a form which in datasheet view.
The form displays courses and dates the employee has taken.
I would also like to use the form to enable the user to select additional
courses and dates.
The course and date fields are combo boxes which query the appropriate tables.

I have entered code on the Course field's After Update property and the
Form's On Current property to requery the date field to enable the
appropriate dates to display.

This is working, however, whenever I select a new course, it erases the dates
in the previous records for the employee.

Any ideas would be greatly appreciated.

Thanks, Marie

 

[Jeff Boyce]

Marie

If I'm understanding your situation, making a selection in a combo box on
one record changes it for all in the datasheet view.

If this is what's happening, consider using the Continuous Form setting
instead. You can set up a Continuous Form to look very much list a
datasheet.

Although, and this is only a personal preference, using something that looks
like a datasheet seems to reinforce the (quite-in-error) impression that
Access is just a big spreadsheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,

I'm having the same problem with my (sub) form in Continuous view.

In my case, I have a task field combo which is used to filter options for a
position combo AND a materials combo. The position combo works fine, and
materials combo works fine in the current record, but once I move to a new
record, the entry in the materials combo vanishes. It's saved to the
appropriate table (options), but just looks (at best) unprofessional, hard to
edit, etc. Also, the edit form built from the same setup displays a dialog
when opening that asks for the task and only displays the material selected
for the same task as entered.

All combos were set up interactively using SQL in the row source.

Thanks for any suggestions.

Marie

If I'm understanding your situation, making a selection in a combo box on
one record changes it for all in the datasheet view.

If this is what's happening, consider using the Continuous Form setting
instead. You can set up a Continuous Form to look very much list a
datasheet.

Although, and this is only a personal preference, using something that looks
like a datasheet seems to reinforce the (quite-in-error) impression that
Access is just a big spreadsheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MarieM via AccessMonster.com]

Jeff,

Thanks for your suggestion. I will switch the form and let you know if I need
any additional help.

Marie

Marie

If I'm understanding your situation, making a selection in a combo box on
one record changes it for all in the datasheet view.

If this is what's happening, consider using the Continuous Form setting
instead. You can set up a Continuous Form to look very much list a
datasheet.

Although, and this is only a personal preference, using something that looks
like a datasheet seems to reinforce the (quite-in-error) impression that
Access is just a big spreadsheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP

My database has a form which in datasheet view.
The form displays courses and dates the employee has taken.

[quoted text clipped - 14 lines]

Thanks, Marie

 

[Jeff Boyce]

Hmmm... I haven't run into that before.

Have you tried searching on-line using some of those terms as keywords?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff,

I'm having the same problem with my (sub) form in Continuous view.

In my case, I have a task field combo which is used to filter options for
a
position combo AND a materials combo. The position combo works fine, and
materials combo works fine in the current record, but once I move to a new
record, the entry in the materials combo vanishes. It's saved to the
appropriate table (options), but just looks (at best) unprofessional, hard
to
edit, etc. Also, the edit form built from the same setup displays a dialog
when opening that asks for the task and only displays the material
selected
for the same task as entered.

All combos were set up interactively using SQL in the row source.

Thanks for any suggestions.