Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Take Data entered on 1 form and populate 2 tables

Status
Not open for further replies.
BHuffer

BHuffer

IS-IT--Management
Jun 22, 2001
6
US
I have a problem with taking Data that is entered into a form and having it poulate 2 different tables at the same time.

Example I am dealing with the Following tables and forms:
1 Table Called IPAddress
1 Table Called IPSubnet
1 Form Called IPTest

The IPTest form is pulling records and fields from a table called IPSubnet and ID. The 2 fields in this table/form that I want to capture are called IPSubnet and IPSubnetID. The IPSubnetID field is an autonumber in the IPSubnet table. When a user populates all information into the Form.IPTest I need to capture the IPSUbnet Field and the IPSubnetID field and have that information ported to the Table.IPAddress and Table.IPSubnet If anyone has any suggestions, please let me know!!

THANKS!!!!
 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
671
OCM
OCM
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
686
dhookom
dhookom
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
304
atadbitslow
atadbitslow
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
231
atadbitslow
atadbitslow
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
636
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top