Inserting Data

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have a form which goes from one form to another
and it moves a refrence number with it... So for example...

On form 1 I have the refrence number as 12345

then I click next (which takes me to another form)

And it automatically pulls up the refrence number (12345)
from the previous form how can I get it to actually add
that data into the table as well as pull it from the
initial form?

Many Thanks

James
 
Hi Jason,

It's hard to say without knowing a bit more - what data do you want to go
into the table? What table? How are you pulling up the reference number (ie
what is the interface between the two forms?)? Give me some more specifics
about the tables, the forms and the fields along with the exisiting code
that is part of this solution and I will be glad to try to assist you.
 
James,

From what your explaning, you want to link multiple records together.
MSAccess can automatically do this by setting relationships between 2 tables
and linking 2 fields together (in your case you could use the reference
number). Search the help files, goto the index tab and type "Relational" as
the keyword. Look through the results and you should be able to figure out
how to do this.

HTH,

Neil.
 
Back
Top