form entry based on combo box/lookup

[Guest]

ok. I have been marauding these forums for awhile now and first of thanks to
all those whom help others out... makes a difference.

This is my first post in here and hopefully this will make sense...


I have three tables.

one for clients
one for employees
and one for hourly charges

this database is going to end up being remotely accessed > still working on
that part as well... but here is my current hurdle...

I have a form that outputs to the hourly charges table but pulls information
from clients for the "PROPERTYNAME" and "COSTPERONSITE". and from employees
for the "EMPLOYEEIDNUMBER" and "EMPLOYEEIDNAME".

I have tried about a million different versions of both
=("[EMPLOYEEIDNAME]","[EMPLOYEEIDANDCONTACT]","[EMPLOYEEIDNUMBER] ='" &
[Forms]!INSERVICEENTRY![OFFICER1] & "'")

Where as OFFICER1 is the drop down for the EMPLOYEEIDNUMBER outputting to
officer name...

and

=PROPERTY.column(2) or =cboPROPERTY.Column(1) etc....

Whereas property is the cbo from clients. and this is attempting to enter
the charge..

I have tried both vise versa and etc...


Every time i try either one it always comes back with #name?

any comments or suggestions?

 

[Guest]

"#name" refers to a field name you are trying to use that isn't being
recognised by the record source.

What are the relationships and what are you trying to do?

 

[Guest]

to be little more in depth...

Tables
EMPLOYEEIDNUMBER
PROPERTYANDCLIENTLISTING
ONSITE
INSPECTION
RESPONSE

Form
INOUTSERVICE -writes to ONSITE
INSPECTION - writes to inspection
RESPONSE - writes to response

The original system has been working great - basically what i am trying to
do is instead of just logging who was where I want to include the billing
cost that is in the PROPERTYANDCLIENT table. When an in/out / inspection /
response is logged the first selection on each is the property then the
employee and it includes a date and time stamp. then weekly we print reports
based on the client and bill with that. Like I said i am trying to integrate
the billing into one system by including the charge that is in the
PROPERTYANDCLIENT table. When you select the property I want it to
automatically fill in the charge. that is where i am stuck and all that is
coming up is the #name? or nothing depending on how I write the code like
below...

thanks again for any help / suggestions

"#name" refers to a field name you are trying to use that isn't being
recognised by the record source.

What are the relationships and what are you trying to do?

--

The 11th day of every month:

http://truthaction.org/forum/index.php

ok. I have been marauding these forums for awhile now and first of thanks to
all those whom help others out... makes a difference.

This is my first post in here and hopefully this will make sense...


I have three tables.

one for clients
one for employees
and one for hourly charges

this database is going to end up being remotely accessed > still working on
that part as well... but here is my current hurdle...

I have a form that outputs to the hourly charges table but pulls information
from clients for the "PROPERTYNAME" and "COSTPERONSITE". and from employees
for the "EMPLOYEEIDNUMBER" and "EMPLOYEEIDNAME".

I have tried about a million different versions of both
=("[EMPLOYEEIDNAME]","[EMPLOYEEIDANDCONTACT]","[EMPLOYEEIDNUMBER] ='" &
[Forms]!INSERVICEENTRY![OFFICER1] & "'")

Where as OFFICER1 is the drop down for the EMPLOYEEIDNUMBER outputting to
officer name...

and

=PROPERTY.column(2) or =cboPROPERTY.Column(1) etc....

Whereas property is the cbo from clients. and this is attempting to enter
the charge..

I have tried both vise versa and etc...


Every time i try either one it always comes back with #name?

any comments or suggestions?

 

[Guest]

I am still slightly confused about your tables.

How are they related? Does a client have more than one property?

to be little more in depth...

Tables
EMPLOYEEIDNUMBER
PROPERTYANDCLIENTLISTING
ONSITE
INSPECTION
RESPONSE

Form
INOUTSERVICE -writes to ONSITE
INSPECTION - writes to inspection
RESPONSE - writes to response

The original system has been working great - basically what i am trying to
do is instead of just logging who was where I want to include the billing
cost that is in the PROPERTYANDCLIENT table. When an in/out / inspection /
response is logged the first selection on each is the property then the
employee and it includes a date and time stamp. then weekly we print reports
based on the client and bill with that. Like I said i am trying to integrate
the billing into one system by including the charge that is in the
PROPERTYANDCLIENT table. When you select the property I want it to
automatically fill in the charge. that is where i am stuck and all that is
coming up is the #name? or nothing depending on how I write the code like
below...

thanks again for any help / suggestions

"#name" refers to a field name you are trying to use that isn't being
recognised by the record source.

What are the relationships and what are you trying to do?

--

The 11th day of every month:

http://truthaction.org/forum/index.php

ok. I have been marauding these forums for awhile now and first of thanks to
all those whom help others out... makes a difference.

This is my first post in here and hopefully this will make sense...


I have three tables.

one for clients
one for employees
and one for hourly charges

this database is going to end up being remotely accessed > still working on
that part as well... but here is my current hurdle...

I have a form that outputs to the hourly charges table but pulls information
from clients for the "PROPERTYNAME" and "COSTPERONSITE". and from employees
for the "EMPLOYEEIDNUMBER" and "EMPLOYEEIDNAME".

I have tried about a million different versions of both
=("[EMPLOYEEIDNAME]","[EMPLOYEEIDANDCONTACT]","[EMPLOYEEIDNUMBER] ='" &
[Forms]!INSERVICEENTRY![OFFICER1] & "'")

Where as OFFICER1 is the drop down for the EMPLOYEEIDNUMBER outputting to
officer name...

and

=PROPERTY.column(2) or =cboPROPERTY.Column(1) etc....

Whereas property is the cbo from clients. and this is attempting to enter
the charge..

I have tried both vise versa and etc...


Every time i try either one it always comes back with #name?

any comments or suggestions?