Making two form fields inter-related

[Guest]

I am creating a data entry form for our company. To make it as easy as
possible for the data entry clerk, I want to have a field that is
inaccessible ( grayed out)whenever data is entered in another first field
field. If no data is entered in the first field, then the related field would
be open for data entry. It is an either one or the other situation. Thank
anyone for help on this.

Shepherdess

 

[Guest]

In the on current event of the form put
if isnull(me.field1) then
me.field2.enabled = true
else
me.field2.enabled = false.
end if

 

[Guest]

just want to ask something, I'm new with this access.
Can you explain to me what will I do to find the right solution to my problem?
It's like this;
I have a field which contain the following;
Home (the look-up will give i.e. AA - apartment, BB - residential, which
when you click will show AA only on the database, it will not include the
description apartment)
Address (DD - New York)

So, what I want is to concatenate the value that will appear on "Home" and
"Address" on the other field ie. "Complete Address" which will be separated
by hypen, semilar with this one "AA-DD"

Once I have the right syntax where should I input that, in excel you can
input that
on the formula but in access dont know where to input.

Please help me.

Thank you

 

[John W. Vinson]

just want to ask something, I'm new with this access.
Can you explain to me what will I do to find the right solution to my problem?
It's like this;
I have a field which contain the following;
Home (the look-up will give i.e. AA - apartment, BB - residential, which
when you click will show AA only on the database, it will not include the
description apartment)
Address (DD - New York)

So, what I want is to concatenate the value that will appear on "Home" and
"Address" on the other field ie. "Complete Address" which will be separated
by hypen, semilar with this one "AA-DD"

Once I have the right syntax where should I input that, in excel you can
input that
on the formula but in access dont know where to input.

Create a Query based on your table. If you have Lookup Fields in your table
(which most developers would suggest you avoid - see
http://www.mvps.org/access/lookupfields.htm for a critique) you will need to
join the Lookup Tables to your main table.

In a vacant Field cell type

Complete Address: [Home] & "-" & [Address]

using the actual fieldnames.

John W. Vinson [MVP]

 

[Guest]

What I mean is, on the same table once I've started to fill-up the fields
"HOME" & "ADDRESS" the value is automatically appears on Complete Address
field.

just want to ask something, I'm new with this access.
Can you explain to me what will I do to find the right solution to my problem?
It's like this;
I have a field which contain the following;
Home (the look-up will give i.e. AA - apartment, BB - residential, which
when you click will show AA only on the database, it will not include the
description apartment)
Address (DD - New York)

So, what I want is to concatenate the value that will appear on "Home" and
"Address" on the other field ie. "Complete Address" which will be separated
by hypen, semilar with this one "AA-DD"

Once I have the right syntax where should I input that, in excel you can
input that
on the formula but in access dont know where to input.

Create a Query based on your table. If you have Lookup Fields in your table
(which most developers would suggest you avoid - see
http://www.mvps.org/access/lookupfields.htm for a critique) you will need to
join the Lookup Tables to your main table.

In a vacant Field cell type

Complete Address: [Home] & "-" & [Address]

using the actual fieldnames.

John W. Vinson [MVP]

 

[John W. Vinson]

What I mean is, on the same table once I've started to fill-up the fields
"HOME" & "ADDRESS" the value is automatically appears on Complete Address
field.

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

John W. Vinson [MVP]