Firstly, apologies as I have absolutely no VB skills whatsoever!
I have a table in which is stored all data pertaining to a "job number"
I would like to create a form where the user enters the job number and all data pertaining to that number is displayed and the user has the opportunity to update the data and add new data into precreated fields, which then populates the relevant fields in the table.
I understand from a different forum that I need to write some Vb to do this, something to do with open recordsets and then updating the table.
Please can anyone help me with this, bearing in mind that I can get as far as a command button and the event builder, and that's about it - sorry
thanks
lynne
I have a table in which is stored all data pertaining to a "job number"
I would like to create a form where the user enters the job number and all data pertaining to that number is displayed and the user has the opportunity to update the data and add new data into precreated fields, which then populates the relevant fields in the table.
I understand from a different forum that I need to write some Vb to do this, something to do with open recordsets and then updating the table.
Please can anyone help me with this, bearing in mind that I can get as far as a command button and the event builder, and that's about it - sorry
thanks
lynne
