red2002yzfr1
Registered User.
- Local time
- Today, 13:50
- Joined
- Jul 19, 2006
- Messages
- 40
When I add a query to a form that has an option group, the option group fails to change when you click another option. Any fixes anyone knows of?
Option Group does not work when adding queries
- Thread starter red2002yzfr1
- Start date
red2002yzfr1
Registered User.
- Local time
- Today, 13:50
- Joined
- Jul 19, 2006
- Messages
- 40
I am using query to count the number of records in other tables.
red2002yzfr1
Registered User.
- Local time
- Today, 13:50
- Joined
- Jul 19, 2006
- Messages
- 40
Bound to a field in a table. I have a form that is bound to a table, but have as of right now, 5 "count" queries bound to fields in the form. When I have those queries in the SQL statement, the option group does not work, just shows the value of what is in the table.
boblarson
Smeghead
- Local time
- Today, 10:50
- Joined
- Jan 12, 2001
- Messages
- 32,040
So, the form is bound to the table by a query or just by the table directly? It should be via a query (you shouldn't go with tables directly, but if you are it wouldn't cause your problem). Your problem is likely caused in the fact that you have your form bound to a query which is not updateable and a query is made non-updateable by several possible factors:
1. There is a calculation in the query itself
2. There are concatenated fields
3. There is a custom column which doesn't appear in the table(s)
4. There is no primary key defined in one, or more, tables that are joined in the query.
If that doesn't help diagnose it, I would say we need to either get you to post your database or let me get it via email so I can see the exact structure of what you are trying to describe.
1. There is a calculation in the query itself
2. There are concatenated fields
3. There is a custom column which doesn't appear in the table(s)
4. There is no primary key defined in one, or more, tables that are joined in the query.
If that doesn't help diagnose it, I would say we need to either get you to post your database or let me get it via email so I can see the exact structure of what you are trying to describe.
