Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

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.
0
lcan4
Asked:
lcan4
  • 5
  • 4
  • 2
  • +1
3 Solutions
 
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
 
GreymanMSCCommented:
What is the query?  Also, what is the bound column?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
stevbeCommented:
more specifically, you can not update any of the controls bound to a field from an aggregate query.
0
 
Rey Obrero (Capricorn1)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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now