must i declare a table in a form?

[jun90]

how come when i call a field (table.field) from a table in a form, it states "compile error. variable not defined"?

eg:
pressure = importedTb.pressure

it highlights the importedTB. must i declare the table in that form first before i can use the table?

how do i reference the table (if i need the value from that table) in the form then?

 

[pbaldy]

If the table is not part of the form's source, you'd have to use a DLookup or recordset to get the value.

 

[ghudson]

Check out the DLookup funtion...
http://office.microsoft.com/en-us/access/HP011004351033.aspx?pid=CH062526711033

 

[jun90]

If the table is not part of the form's source, you'd have to use a DLookup or recordset to get the value.

what is a recordset? can show me an example?

thank u!

 

[pbaldy]

If you search this site on "recordset" you should find numerous examples. I'd also specify DAO, since that is the easier to learn in my opinion (the other type is ADO).