Control sourse!!

[dr223]

Hallo,

I am working with access 2003, I have a table called qual_hist. I have added a new field called inst_name(to store the name of the institution). However, when I go to the respective text box on the form (design view) on the control source inst_name is not shown.

Though, it is in the table qual_hist. The rest of the fields are all shown.

Can anyone help me, to find a way to be able to save to inst_name for future retrieval.

Thanks

 

[Guus2005]

Probably you are using a query to which your Form is bound. Adjust this query to display inst_name.

HTH

 

[dr223]

I have added it on the query design, inst_name.

However, it is not showing on the control source neither...

Am i doing anything wrong????

 

[Guus2005]

Did you run the query in design mode? Did you see the new field?

Post a sample db (zipped not rarred)

 

[dr223]

Contro source

I run the query and I never saw the new fields either

Please find a copy of the database, thanks

 

[ahuvas]

I cant see the new field at all in the table just inst_name1,2 & 3. Are you sure you created it?

 

[dr223]

Yes, and thats the name of the fields inst_name1,2 & 3. I would like the data to be stored on these fields respectively.

 

[Brianwarnock]

You have to add those fields to the Form , it wont happen automatically.

Brian

 

[Brianwarnock]

I notice that your form is not based on the full query but a Select from the query, thus that will also need changing to make the fields available.

Brian

 

[dr223]

I have one of the field's on the form. The idea was to do one first get it right then do the other two. So, presently, I want to have the inst_name1 working then will carry on doing inst_name2, inst_name3.

The problem am facing is storing the result to the table. The control source is not giving be an option of inst_name1, though it is present in the query and table...

I hope am clearer.. thanks

 

[dr223]

Sorry, where will I have to change it to full query...

 

[dr223]

Thank you guys, I have sorted it......
Special thanks to Brianwarnock you pin pointed the problem.

Many thanks to all