user entering the data

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

region carrier

North
east
west
northeast
southwest
south

the above table , the carrier field is empty. i need a query or a form
which should ask the user to enter
the following
enter the northern carrier - sai
enter the souther n carrier = bai
enter the eastern carrrier = sa
enter the southwest carrier = rt

once the user enters the info, the tabl e should get automatically
updated as follows

North sai
east sa
south bai
southwest rt

Is there a form that can be created or even a query to get the above o/
p

thanks
 
Use the form wizard to create a continuous form. This is all very basic and
the data entered into the resulting form will be saved in the table.
 
Use the form wizard to create a continuous form. This is all very basic and
the data entered into the resulting form will be saved in the table.
--
Duane Hookom
Microsoft Access MVP









- Show quoted text -
Click to expand...

Hi Duanne

thanks for the reply but what would i do if there are multiple
records and the user want to enter only once
for example

Region Carrier
North
North
North
south
west

Now the form should ask for the carrier for northern region only
once . It should then populate the first three rows with the same
answer.
 
If the Carrier is always the same for a particular Region then you should not
have the record entered more than once in a table.

I have a feeling you are only revealing your needs a small bite at a time.
I'm not sure where these questions are headed or what your real needs are.
 
Back
Top