Adding data from one form to another

[ldappa]

Hi,

I'm trying to add information from one form when i look up a particular
student and append it to another table when i open the form to append that
table.
How do I do this?

Thanks,Lorna

 

[ldappa]

Hi,
We have a main system which I link to and was asked to create a small
program to gather data from students for information that is separate from
the mainframe. Instead of typing in the students id ,name etc. again in my
smaller database I have a lookup form which the data is pulled from the
linked table and would like to append each student i pull into the smaller
table.

thanks

 

[Jeff Boyce]

If the data is already available by query, why do you believe you need to
"append each student ... into the smaller table"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hi,
We have a main system which I link to and was asked to create a small
program to gather data from students for information that is separate from
the mainframe. Instead of typing in the students id ,name etc. again in
my smaller database I have a lookup form which the data is pulled from the
linked table and would like to append each student i pull into the smaller
table.

thanks

 

[ldappa]

Because it's going on a separate computer which is not networked and will
not have the connectivity to pull the query.

If the data is already available by query, why do you believe you need to
"append each student ... into the smaller table"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mike Painter]

Then just use queries to import the data and forget about doing it in forms.
Transfer it to a thumb drive and move it to the standalone.
You will need one query to add new students and one to update existing rows
with new information.
As long as you have rigid policy in place about updates and changes and have
a method for updating and adding new informationthere may not be any
problems for a while.

Not that it is likely to be much help but I would get this kind of request
in writing as high up the food chain as possible.

 

[ldappa]

Thanks, I think I will do that.
Lorna;

Then just use queries to import the data and forget about doing it in
forms. Transfer it to a thumb drive and move it to the standalone.
You will need one query to add new students and one to update existing
rows with new information.
As long as you have rigid policy in place about updates and changes and
have a method for updating and adding new informationthere may not be any
problems for a while.

Not that it is likely to be much help but I would get this kind of request
in writing as high up the food chain as possible.