Hello and thanks in advance for any advice
I have created an unbound access form which pulls information from an excel sheet along with adding additional information such as dates. The form works perfectly and looks up the excel sheet and has dependant drop downs etc. I was quite proud of myself (I'm a novice as you can probably tell)
The excel sheet is a list of raw materials delivered daily but some details change such as use by dates.
What I want to do is fill in the access form and then ideally click a button and the information from the form goes to another excel sheet. The form is then cleared (I've done that bit with a separate button) and the next information put into the form is then saved below the previous record on the excel sheet.
Is this something that can be done easily and can anyone please help a newbie out?
I realise that I may sound completely stupid but I am trying
Thanks very much for any assistance you people who are so much cleverer than me can provide.