Search results

I have created a db with several forms linked by a autonumber ui, I wish to create a search function that will pull records from the database and ideally display the results on a form as opposed to a data sheet - any ideas on how best to approach this?

I am using a multipage form and on the 2nd page I am calling some records from a particular table using the below code, the first record works fine but the others are displaying #name? despite being the correct field names and using the same format as the working code - any ideas...

not sure if this is even possible but I would like to only display certain fields on a form depending on a criteria in another cell. For example if some enters 4 in 'Schemes' it would display 4 data entry boxes scheme1, scheme2, scheme3 etc - is it possible?

Hi I am very new to access so apologies if this is very simple but I have created a database with 3 tables customers, products and orders, I have created a one to many relationship between customers and orders and want users to input using a form, so I have created a customer form and want to...