Combo Boxes and queries, strSQL (Easy...again) 1

[Emblem1]

Hi.

I just want to say first that Tek-Tips is the greatest things since sliced bread! I sure have learned a lot!

On a form I have 2 combo boxes - Sign1Type, and CSign1. Sign1Type gets it's data from a query, which in SQL
view is like this:

SELECT tblSigns_forwattageForms.[Sign ID], tblSigns_forwattageForms.Description, tblSigns_forwattageForms.[Face Size], tblSigns_forwattageForms.[Lighting Type], tblSigns_forwattageForms.[# Bulbs or Panels], tblSigns_forwattageForms.[# Faces], tblSigns_forwattageForms.[Total Wattage]
FROM tblSigns_forwattageForms
ORDER BY tblSigns_forwattageForms.[Item Number];

[Sign ID] is selected by the user in the Sign1Type combo box. I then want to place the [Total Wattage] data, from column 7 for the selected Sign ID, into the CSign1 combo box. I still haven't figured out the strSQL coding for vba yet.

Thanks in advance.

 

[PHV]

A starting point (in the AfterUpdate event procedure of Sign1Type):

MsgBox Me!Sign1Type.Column(6)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Emblem1]

ok...that WAS easy.

I did this...

Me.CSign1.Value = Me.Sign1Type.Column(6)

So I assume that the first column is considered column 0 (zero)?

 

[HarleyQuinn]

So I assume that the first column is considered column 0 (zero)?

Yep

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post