Re: Need help setting up first query

Dear J:

Just address me as Tom, if you please.

SQL is the "code" for a query. Any query you can write may be expressed as
SQL. This code may be placed into the RowSource of the combo box ("drop
down") for assignment to change its behavior.

Your original post said:

"I need the value entered here to restrict the data available on the next
drop down box (called assignment)."

This indicated to me that the combo box's list would change every time
something was selected in the SignUp. Right?

There is an "event" that occurs every time the SignUp comb box is changed,
called "Click". In the code for that event, you can recover the new value
selected in the SignUp and use that to filter the query to be used as the
Assignment combo box. Perhaps you used the automated methods to create the
current query that operates the Assignment combo box. If you would look at
the RowSource property of the Assignment combo box, you may see there is
some code placed there by your programming. Copy that into your next
message. Perhaps I can figure out something from that. Also, please
provide the name of the SignUp and the Assignment combo box controls.

Tom Ellison


"Jdougal via AccessMonster.com" <u19152@uwe> wrote in message
news:5d257e69b14b7@xxxxxx
Mr. Ellison,

Thanks for your help thus far,

I'm very new to Access and have no SQL access. Is there anyway you could
provide me with a little futher assistance?

Also thanks for the second suggestion for the message, I did not even
think
of that.

Tom Ellison wrote:
Dear J:

The technique would be to assign the SQL for the second "Assignment" combo
box whenever a selection in the first "SignUp" combo box is made. The
Click
event of the SignUp combo box would be ideal for this.

If the focus (Got Focus event) is placed in the "SignUp" combo box and
there
is no "Assignment" selected, you may want it to display nothing, perhaps
exhibit a MsgBox, and pass the focus back to the "Assignments" comb box.

Tom Ellison

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200603/1


.

Relevant Pages

  • query birthdates occuring in year range
    ... The following is my sql view of a query I have put together to return the ... year of a member's 100th birthday. ... My assignment is to generate a report for ...
    (microsoft.public.access.queries)
  • RE: query vs docmd.runsql
    ... There is no command that will run a select SQL, to open a select query you ... datetab.date) INNER JOIN CoreChart ON APhist_PS.Account = CoreChart.Core ... summary queries in the string assignment, ...
    (microsoft.public.access.queries)
  • connection from c# to sql server 2005
    ... I am doing a small asssignment in which i have to create a small ... that file and then connect to sql server 2005 and execute the query ... please help me to finish this assignment. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Trying to work out a join
    ... left box is a group of members who arent assigned this one file ... remove the assignment. ... The SQL for the right box is the one that works as we only need this SQL ... The left box uses this SQL as a sub query to exclude memberID's NOT IN that ...
    (microsoft.public.inetserver.asp.db)
  • Re: Updatable Query (trying to edit records)
    ... the query so some fields are lookup fields. ... The only reason the Staff table is ... CABudgetHrs to arrive at the budgeted $ for that assignment. ... two tables ClientAssignment and Staff. ...
    (microsoft.public.access.queries)