SELECT DATA TO VIEW IN DROP DOWN ON FORM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akrt48 - 19 Nov 2005 20:38 GMT

Can anyone please tell me what I have done wrong in this statement? I have a
Form with a sub form on the sub form I want to limit the Blocks that show up
in a drop down form to the jobs that are assigned to Divisions. I have a
table called jobs with the fields Block and Division which are in my sub
form. When I enter a Division the block column shows blank fields. I have
bound the right column to the Block field. Thanks

SELECT Jobs.Block FROM Jobs WHERE
(((Jobs.Division)=Forms!timeslips![operatinghours Subform].Form!division))
GROUP BY Jobs.Block ORDER BY Jobs.Block;

Reply to this Message

Douglas J. Steele - 19 Nov 2005 21:12 GMT

What's the context behind the SQL? Is that what you copied-and-pasted from
the SQL view of a query, or is it something you're trying to use in VBA
code?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Can anyone please tell me what I have done wrong in this statement? I
> have a
[quoted text clipped - 9 lines]
> (((Jobs.Division)=Forms!timeslips![operatinghours Subform].Form!division))
> GROUP BY Jobs.Block ORDER BY Jobs.Block;

Reply to this Message

Ofer - 19 Nov 2005 21:20 GMT

On the after update event of the devision, did you refresh the Jobs combo?
If not put thid code on the after update event of devision

Me.[enter here City combo name].Requery

Signature

Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

> Can anyone please tell me what I have done wrong in this statement? I have a
> Form with a sub form on the sub form I want to limit the Blocks that show up
[quoted text clipped - 6 lines]
> (((Jobs.Division)=Forms!timeslips![operatinghours Subform].Form!division))
> GROUP BY Jobs.Block ORDER BY Jobs.Block;

Reply to this Message

Akrt48 - 19 Nov 2005 23:13 GMT

Thanks Ofer, thats all it took.
Can't believe I missed it.

> On the after update event of the devision, did you refresh the Jobs combo?
> If not put thid code on the after update event of devision
[quoted text clipped - 11 lines]
> > (((Jobs.Division)=Forms!timeslips![operatinghours Subform].Form!division))
> > GROUP BY Jobs.Block ORDER BY Jobs.Block;

Reply to this Message