Data not being recorded in record table??

[goju]

i have a combo box where i select a CityTown the next text box identifies the county and the next identifies the postcode.

when inputting this works fine, but when i check the data table it has not recorded the information.

the city town county and postcode run from a table to query to the form.

i am worried that i am not recording the data and that i will lose esstial information.

any ideas

 

[Mile-O]

Who is building this database? You or us?

I strongly suggest you do some reading on the subject, including the manual, rather than asking a question for every little thing you get stuck on.

 

[goju]

SJ,

i thank for your help over the last few weeks.

i am trying to learn and feel i understand a lot more now.

you dont have to answer my questions.

i am reading searching, and trying to unserstand. if i get stuck im sure there are people willing to help.

and in years to come if i can help other people i will.

not all of us understand access like you.

thanks anyway.

 

[Mile-O]

I understand you are learning but the sheer volume of questions from yourself is amazing. I suggest maybe next time compiling them all into one thread.

Anyway, if your textbox automatically puts the post code and county into the other controls then there's no need to put these into the table.

Also, here's some reading Normalisation and Understanding Relational Database Design. Lookup Third Normal Form in these and you'll see why you don't need the information in the table if it is already calculable.

 

[The_Doc_Man]

goju, how you store data depends on how you get it.

If you created the controls with a Wizard and told it to do a lookup, that does not automatically store anything. What Access does with the value you looked up depends on a different question that the Wizard asks.

The control still has to be bound to a field that is a member of your updatable recordset that underlies the form. If this is not the case, you need to assure that the binding of control to recordset occurs.