Form Wizard

[lorraine]

Can any body tell me if I'm wasting my time?

I want to create a form linking 5 tables, can I do this using the wizard, so far every time I've tried the form just comes up blank!!

Ta

 

[Atomic Shrimp]

Have you tried linking the 5 tables in a query and telling the form wizard to use that?

if so, when you open the query on its own, do you get any rows returned? (it could be that your linking or criteria results in an empty recordset)

Mike

 

[lorraine]

Ta for the reply

I have not tried the query but I will do!

Just a quick question!
What is exactly meant by recordset?
I've had this mentioned on forms before, ie, 'Staff_dets' is not in recordset and I didn't know what on earth it was going on about, I'm pretty new to this computing stuff!!

 

[Atomic Shrimp]

A recordset is the way that access stores in memory the data returned by a query - the rows that you see when you open the query in datasheet view are a recordset; a selection of rows/fields from a table, in old-fashioned programming terms its similar to an 'array'.