Update Query

[Daryl2106]

Hi, I have a form that run a query to select all the students taught by a given faculty member. Once the records are loaded, the faculty enters attendance data, selects a date from a combo box and hits a save button.



I change my relationship and now need to be able to store the key for the field in the combobox and not the text.

How do I set the field, table and criteria in the update query to do this. The UD query uses the FacultyStudents query as its record source. Currently the FacultyStudents querry does not have the Key or the date fields since the date is selected by the faculty once their records are loaded. As I see it there is now way to make a join, so I think I either need VBA or SQL, which I am not very good (really bad) at wriitng. Can the necessary Sql be written in the query design view?

Thanks and take care,


Daryl

[June7]

Why is a date value selected from a combobox? What is the data source for combobox RowSource?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Daryl2106]

Hi JUne,

Thanks for the reply. I guess I was trying to make it as user friendly as possible. The dates come from a seperate table (AttendancePeriods). I guess the easiest and best was to proceed is simply have faculty to select the date and then store the key in the date field of the StudentAttendance Table? Does that make sense?

[June7]

Yes, that does. Need a multi-column combobox. Review http://datapigtechnologies.com/flash...combobox3.html

[Daryl2106]

Thanks so much June. I will save the link. I am sure I'll need it at some point.

Take care,

Daryl