access table field question

[simplerequest]

oh you got it really

[RuralGuy]

...and what table(s) are we trying to update? It looks like this data has been imported from an Excel file. True?

[simplerequest]

the working rec reports form perfoorms the function I am trying to get
when the combo box is used and a facility number selected the name box fill with the correct facility name

[simplerequest]

some of the table were from an excell file

i am unable to get the form to fill the table because I made correction to the form and not on the original table rec reports

there are a few different version of the form and table becuase if i deleted the tables or forms , the form would no longer work

[simplerequest]

in the forms area the working rec report form if viewed from the design view and select the datasheet view the forms works perfectly but you cannot save the form in the table view

[RuralGuy]

Here's a link you need to read: The Evils of Lookup Fields in Tables

[RuralGuy]

Have you done any reading on Normalization of tables? There are a number of issues with your structure that will continue to cause you grief until the tables are normalized.

[RuralGuy]

...but you cannot save the form in the table view

What does this line mean? What is the Table view?

[RuralGuy]

Did you get my last email?

[simplerequest]

look in the form table working rec reports selecting the design view drop down and select the datsheet view

a table will appear this datasheet view appears to be a table but it is not.

[simplerequest]

email on yahoo?
going

[simplerequest]

no RG I have never read anything on normalization
i just quickly read the Evils of Look Up Fields in Tables

what i read makes me think that I am really way out in left field

is it after 3 am where you are? where are you and do you ever sleep?

[RuralGuy]

look in the form table working rec reports selecting the design view drop down and select the datsheet view

a table will appear this datasheet view appears to be a table but it is not.

This is the Datasheet view of the form and can be made the default if you want. You can not see the command button on your form in that view.

[RuralGuy]

It is only 9:30 PM here right now and I do sleep...often ;). What you have can be fixed but you really need to do some reorganizing first. How much time do you have on the project? Days or weeks perhaps?

[RuralGuy]

We can pick it up again tomorrow if you want.