updating fields in table from field in another table 
Author Message
 updating fields in table from field in another table

Hi,

I'm quite new to Visual Basic and Access so this problem I hope has a
simple solution.

While filling in a form for table A,
Using a sub procedure (via command button) I want to
open up the form corresponding to table B and update a field with
data entered into a field in table A.

Can this be done easily? If so would you be so kind to include
as much code as possible due to make novice state.

Thanks for any help you can provide!!

C
--



Fri, 05 Feb 1999 03:00:00 GMT  
 updating fields in table from field in another table

Quote:

> Hi,

> I'm quite new to Visual Basic and Access so this problem I hope has a
> simple solution.

> While filling in a form for table A,
> Using a sub procedure (via command button) I want to
> open up the form corresponding to table B and update a field with
> data entered into a field in table A.

> Can this be done easily? If so would you be so kind to include
> as much code as possible due to make novice state.

> Thanks for any help you can provide!!

> C
> --


Cynthia,

        FormB.TextBox.Text = FormA.TextBox.Text
--

Thanks,
Dave Verschleiser
Q&D Software Development - http://www.q-d.com
Creators of WebForms and WebMania!

=======================================================
For the best SHAREWARE on the Net, check out:

** The Shareware Central Interactive Catalog **
** http://www.q-d.com/swc.htm **

Shareware authors -- find out how to obtain a listing!
=======================================================



Sun, 07 Feb 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. update table field from xref table

2. Create new fields in a table based off of fields in another table

3. Create new field in existing table exactly like field in second table

4. Fill field in one table from field in another table

5. Use report fields to update table fields

6. Using--After Update-- to update field in table.

7. Copy fields from record in table A to record in table B using VBA

8. Create table from a combined field in another table

9. Subtracting qty from a field on one table from qty used on another table

10. using table field names after table connect

11. Help Help Need to copy a field from one table into another table

12. Update a Field ina Table

 

 
Powered by phpBB® Forum Software