Silly List Box Query

[jodilees]

I have created a form from 3 different tables. I used the wizard to create it.

I have just realised that there is a field that I did not incorporate when I used the Wizard.

How do I go about getting this field onto my form. It is not in the list box.

Kind Regards

Jodi

 

[bradcccs]

Sunny Queensland - Half your luck!


When you used the wizard to create the form, it would have compiled a query as the basis for your form (called the record source).

You will have to edit the record source in order to include your extra field.

Bring up the properties of your form, and then select the elipse (...) next to record source. This will take you to the "Query Builder" that you are used to seeing whilst building queries. Add you field as required.

Let me know if you need further direction.


Brad.

Sunny Victoria (at least it is today )

 

[jodilees]

Thanks brad

Your a legend, yes got it now, I knew it was something simple, I am still so rusty on all of this stuff.

Glad to hear Vic is sunny today, I used to live near mt Gambier, approx 30km from the Vic Border in SA so I know Vic quite well.

Go the Blues!

Jodi

 

[bradcccs]

Your from SA, live in QLD and go for the Blues???

Go figure??


Carn the Dees!

 

[jodilees]

I grew up watching Vic TV as that is what was broadcast to our area. Took a liking to the Blues as a kid and now I am obsessed, absolutely hate the crows and port!

Can't help it, only been in sunny Qld for 3 months and can't possibly change teams now!

Jodi

 

[bradcccs]

After last years season, I thought you would have taken any excuse to change teams!