Recent content by turnej

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...

Every record(customer) will have a different amount of schemes so my thinking was not to have unnecessary boxes on forms if they are not needed for that particular customer but for some customers they may be

thanks hopefully someone who knows vba will reply

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...