lookup table

[Danny]

Greetings,
I have created a database to track applicants eligibility process. Just recently, I was approached to add a new field to find out how applicants know about our program (through Friend, Family, School, other etc.)
So I created a lookup table and added a new field 'AppSource' to an existing table (tblHouseHold), and created relationships. My questions:
1. On my form I do not see the dropdowns for the new field 'AppSource'
2. How should the query look like so I can get a total # for each AppSources. For example 80 applicants learn about our program throug Friend, 50 applicants learn about our program thrugh School etc.



Thanks,
DKD

 

[KenHigg]

1. Sounds like you created the form with a wizard... If you used the table as the record source, just open the fld list window and drag the fld over.

2. You can do this with a simple count query...

kh

 

[Danny]

Ken, thanks for your reply.
I'm not sure if this is the right way, but, I opened the form in design view, drag AppSource field and tried the new field, still do not get the drop down option. And what type of query do I need to use (select, crosstab etc.) and what are the fields need to be in the query grid?

Thanks
DKD

 

[Electric Ant]

Hello Danny

I'm new to Access so this may be the wrong way of doing it but it worked for me.

1) I also created most of my form with a wizard and it didn't always lookup like I wanted it too. One way I found of changing it by experimenting was to go to your form in design view. If you have a text box and not a dropdown list or combo box, then click on the AppSource control with right mouse and select 'change to' and changed text box to combobox. Then to get it to lookup form your lookup table, right click again on the AppSource control and select 'properties'. In the RowSource click on the three dots at the right ... to get the query builder, select the lookup table and drag the field in the lookup table to the query grid.

2) I think you need a select query but drag AppSource field into query design grid twice, in the Totals row change one to 'group by' and the other to 'count'???