473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Two fields two forms that update each other

2
In Access 2007 I have two forms - one called Customers and the other called SWZ. There is no relationship between the two forms. The SWZ form has two fields Account Number and Application Number. The Account Number field is prepopulated with Numbers.

The customer form also has two fields one called Appno and the other is called AC number . Appno is prepopulated with numbers.

I need to do the following from the customer form:

Open the swz form and populate the first record Application Number field from the Appno field on the Customer form

Then take the Account Number from the same record in the SWZ form and populate the AC number field in the Customers form.

I havent got a clue where to start.

Help please
Nov 27 '08 #1
3 1747
PianoMan64
374 Expert 256MB
@NigelD
Hello NigelD,

Welcome to Byte.

To answer your question, what I would suggest to you is simply have the field you want to populate with a combox and fill it will the values from the Customer table that the customer Form is based on. and the same on the customer form with the table that the SWZ form is also based on. This way you can access the information without having one or the other form open at the same time.

It is never good practice to try to create a link between two items with both being created at the same time. To much room for failure.

Hope that helps,

Joe P.
Nov 28 '08 #2
NigelD
2
To answer your question, what I would suggest to you is simply have the field you want to populate with a combox and fill it will the values from the Customer table that the customer Form is based on. and the same on the customer form with the table that the SWZ form is also based on. This way you can access the information without having one or the other form open at the same time.

It is never good practice to try to create a link between two items with both being created at the same time. To much room for failure.
I had thought of this, unfortunately the SWZ table contains unique ID's in the Account number field Yes I can look up the next free Account number using a combo box and saving the Account number in the Customer.AC Number field the problem then becomes one of filling the SWZ.Application number field from the customer.App no field without taking two actions

The SWZ query is based on Application Number is not null which ensures that duplicate Account Numbers dont appear in the Customer table.

So is there a way when I select the Customer Account number using the combo box a pop up form opens and selects the record from the combo box and populates the SWZ Application Number field or something along those lines
Nov 28 '08 #3
PianoMan64
374 Expert 256MB
Hey NigelD,

So what is the relationship between the two table?

1. Is it that you can have Multiple SWZ records with One customer?
2. Is it that you can have Multiple Customers under one SWZ record?
3. or is it simply a one to one ratio between the two tables, and you're wanting to create an linking ID between them to tie them together as one Item?

Let me know, cause what you've explained doesn't make much sense to me.

Thanks,

Joe P.
Nov 30 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Almir | last post by:
I have a simple problem, i just can get a grasp on it. I designed a database for inventory of computer equipment. Now i created forms for each table. Each piece of equipment is going to come in an...
2
by: Richard Holliingsworth | last post by:
Hello: Thanks for reading this. I would like to make some on the fields on my Access 2002 Form updatable only by an admin (or privilidged user). I can't find any references to this in the...
1
by: MissiMaths | last post by:
I am creating a reference table of all the information used to draw a sample. I start by first clearing the table in form1 using a delete query. Then after the user selects certain options, i...
6
by: allyn44 | last post by:
HI--what I am trying to do is 2 things: 1. Open a form in either data entry mode or edit mode depending on what task the user is performing 2. Cancel events tied to fields on the form if I am in...
8
by: Maxi | last post by:
There is a lotto system which picks 21 numbers every day out of 80 numbers. I have a table (name:Lotto) with 22 fields (name:Date,P1,P2....P21) Here is the structure and sample data: ...
18
by: TORQUE | last post by:
Hi, Im wondering if anyone can help me with a problem. I have a form with more than 50 unbound fields. Some of the fields will be blank from time to time. This seems to be where im having...
1
by: Elainie | last post by:
I have two tables and two forms, "Patient Details", "Placement Details". In the "Patient Details" form, I have the name and addresses fields. I want to update the addresses fields automatically...
4
by: jayscott1 | last post by:
What I would like to do is have the user start typing in the last name and as they were typing it would retrieve names from the database and give a drop down like autosuggest in google. That much...
1
by: munrrob | last post by:
MS Access 2002 SP 3 I have two forms, one with a combo box looking at available lookup tables and the other an unbound form which will be used by the user to update lookup values. The lookup...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.