Comboboxes not allowing selection on forms, record source from more that 1 table/quer

[theresa]

Hi, I have been trying to get two combo boxes that will allow users to enter information into the database, store the information, view it and edit it. They work on the table but will not allow edits in the forms. I've tried everything I can think off and some that were on other posts but nothing has worked. It made it worse so I'm back to an earlier version. I think it has something to do with the record source being from more that one table/query as the one form that is working is based on only one table. Can anyone help. I'm unable to upload the database as even zipped it's too big

[June7]

A form can enter/edit data to only one table.

Possibly you need a form/subform arrangement.

Did you run Compact & Repair on the db before zipping?

[theresa]

yes but it's still 6,858kb after both. I've been trying form/subform but they're connected through a join table so that's not working out

Here's an image of the table relationships

[June7]

This isn't the issue you indicated resolved in https://www.accessforums.net/forms/f...add-42721.html ?

[theresa]

Thanks for getting back so quickly June7. no that thread was to make it easier to fill in a form by selecting from a dropdown list of clients on waiting list, this is when I want to edit client details once the client has entered into counselling. To do this I need to combine information from the client and counselling tables on to one form e.g. to see all the information on a client and select the finishedcounselling yes/no box if they have finished their counselling at the centre. The referral issues and times available can also change during Counselling so I need these to be editable. The combo boxes that I have on the client table will not allow and changes. Another issue I having is when the form is based on a query of the clients table e.g. to show only the current clients, I am unable to use those combo boxes, I would have to go through all the clients the service ever had on a form based on the tblClients. I'm thinking along the lines of a filter but the conditions of the filter would also be based on another table namely the tblcounselling so I don't know if that'll work, any ideas would be helpful

[June7]

And why doesn't form/subform work?

Main form bound to tblClients and subform bound to tblCounselling. Only that client's counseling records will display in the subform.

Can use the intrinsic Access filter tools (right click in any field) or use UNBOUND controls to enter/select criteria along with code (VBA or macro) for filtering records. Filter the main form for the desired client.

[theresa]

Thanks so much June7, My brain has officially stopped working (2hrs sleep last night). I'm gonna hit the sack and try those tomorrow, I'll let you know how I get on

[Missinglinq]

...I have been trying to get two combo boxes that will allow users to enter information into the database...They work on the table but will not allow edits in the forms...

This sounds as if you're using Lookup Fields at the Table-level, which is not a good idea:

http://www.mvps.org/access/lookupfields.htm

Are these Lookup Fields in the Table?

Also, as you've found out, a Form bound to a multi-table Query is usually Read-Only/No Editing Allowed, and the Access gnomes consider the use of a Combobox to be editing, hence their not working on this Form.

Linq ;0)>

[theresa]

You're correct Missinglinq, I've lookupfields in my TblClients for both the presentingIssues and Days/Times Available fields.

Thanks again June7. I used your suggestion, I have the form set up with a subform and placed an unbound combo box on main form to search records on form through the wizard and then changed the row source to SELECT [qryCurrentClients].[ClientRefID] FROM qryCurrentClients; instead of SELECT [TblClients].[ClientRefID] FROM TblClients;

This works perfectly. I would prefer to use a textbox where the user could enter the ClientRefID directly instead of looking through what could be a long list in a combo box but after 12hrs of research, I've been unable to find a way to do that without the form loosing it's data entry capabilities