One field or another field

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I created a form with a subform based on a 1 to many
tables. In the accounts table I have two fields; one for
domestic Tele no [(xxx) xxx-xxxx]. But International tele
numbers are different so I created a field for ITele no
with no parameters. Right now when the form is called up
it asks for a domestic telephone number. If the tele no
is in the Accounts table it bring us the basic customer
information for that number. But if it is a international
tele number it won't work. How do I make a field that
will ask if it is domestic or international and put the
tele number into the correct field. I want either or tele
no to bring up the customer information.

Does anyone have any ideas?

Aurora
 
Something like

txtTele = nz(Tele,ITele)

should work.

But I would query the wisdom of having two fields for telephone numbers.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thank you for your answer - I thought I tried this but
will try this again.

I am open to any other suggestions as to how to pull up
customer information from either a domestic tele # or an
international tele number. If you would like to e-mail me
I am at (e-mail address removed)

Again thank you for answering.
Aurora


-----Original Message-----
Something like

txtTele = nz(Tele,ITele)

should work.

But I would query the wisdom of having two fields for telephone numbers.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
I am using Access 2000

I created a form with a subform based on a 1 to many
tables. In the accounts table I have two fields; one for
domestic Tele no [(xxx) xxx-xxxx]. But International tele
numbers are different so I created a field for ITele no
with no parameters. Right now when the form is called up
it asks for a domestic telephone number. If the tele no
is in the Accounts table it bring us the basic customer
information for that number. But if it is a international
tele number it won't work. How do I make a field that
will ask if it is domestic or international and put the
tele number into the correct field. I want either or tele
no to bring up the customer information.

Does anyone have any ideas?

Aurora
Click to expand...


.
Click to expand...
 
Back
Top