Query Not Found

[TheShabz]

I'll be taking a look at your db tomorrow. So I will probably see why its confusing you then. The way I understand it is that you want to have a form where the user can select a member, and use a check box to set him or her to a "retired" status. Using my idea above, yes, it would give you a list of all members in the combobox. then you check the box. the update query would take the name in the combobox and use it in its "WHERE" clause to set that member to "retired".

[brooke48]

You've got the requirement right. The db switchboard opens with blank member record fields and specific records are obtained through member no. or surname searches. When a member's records are visible, the check box should update the record to "retired" and change the "commitment" (individual status) - shown in the Subscription Information Form - to retired. This retired status is paired with a given membership fee (list of all status types and values contained in Commitment Types table.

My confusion about the combo box was the thought of having to type the entire list of members into it but you didn't actually say that !

[TheShabz]

I should have spotted this earlier. Your db only contains the front end (the FE on the filename should have given it away to me earlier). All of those tables and forms are linked to the computer of whoever Richard is. It's a split database. I cant do anything without seeing the tables and forms.

[brooke48]

Sorry - I should have mentioned the split. Data tables attached

[brooke48]

Hello TheShabz - how's it looking ?

[maximus]

he I just tried to open the db that you have uploaded happens that the tables are Linked tables can you please upload your db with all the tables Queries forms and reports in one mdb file.

[brooke48]

Have merged to one mdb as requested.

[maximus]

You've got the requirement right. The db switchboard opens with blank member record fields and specific records are obtained through member no. or surname searches. When a member's records are visible, the check box should update the record to "retired" and change the "commitment" (individual status) - shown in the Subscription Information Form - to retired. This retired status is paired with a given membership fee (list of all status types and values contained in Commitment Types table.

My confusion about the combo box was the thought of having to type the entire list of members into it but you didn't actually say that !

I have downloaded your database and I see a lot of queries and tables can you no guide me step by step what you want.

Note Please refer all Field with the reference to there tables.

I am sorry if this is extra trouble for you. I am not very good but can try to solve your problem.

[brooke48]

The problem is that the convert to retired check box does not update the current record in the commitment table. The individual status should change to retired and the corresponding subscription fee should also change.