Combo box now allowing me to select a record

Why can't I select a value from a combo box with the control source as a query? where I have grouped and selected Max records.  I only need the Max records from this table for this form.
lcan4Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
stevbeConnect With a Mentor Commented:
more specifically, you can not update any of the controls bound to a field from an aggregate query.
0
 
Rey Obrero (Capricorn1)Commented:
control source as a query?

the query should be in the row source not control source.
0
 
lcan4Author Commented:
It is the Record Source actually.... my mistake -
When I use the query without grouping I can select from the combo box, but not when I add grouping and Max
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
GreymanMSCConnect With a Mentor Commented:
What is the query?  Also, what is the bound column?
0
 
Rey Obrero (Capricorn1)Commented:
again, there is no record source property for  a combo box.

is the query against a single table?
0
 
lcan4Author Commented:
Yes you are right - and yes the query is against one single table.  
0
 
Rey Obrero (Capricorn1)Commented:
weird, just tried it and it is working here.
can you post the query and setting of combo properties
0
 
Rey Obrero (Capricorn1)Commented:
is the combo bound to a field?
0
 
stevbeCommented:
you can not update any field on a form that is bound to an aggregate Query.
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
agreed, that is why my last post was asking the questioner about the combo being bound.
but the problem with this questioner, is not responding back to confirm what is being ask.
0
 
lcan4Author Commented:
I am back and let me see what I can post to better describe - Thanks
0
 
lcan4Author Commented:
I think stevbe answered the question.  I have to group a table in a query to get max records and I believe that is the problem.  I do not know what to do now except create a make table query to populate a table then work from that table to update the records I need to in the form and then update the main table.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.