form entry based on combo box/lookup

G

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?
 
G

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?
 
G

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



scubadiver said:
"#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


oddj said:
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?
Click to expand...
Click to expand...
 
G

Guest

I am still slightly confused about your tables.

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



oddj said:
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



scubadiver said:
"#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


oddj said:
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?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number increment depending on a combo box entry 6
combo box, how to limit to client table 1
Combo Box Problem 6
CmdButton enabled based on Combo Box data 6
Populating a form from combo box 3
Combo Box to update fields in a form 2
New records don't display on form with combo box 1
Populate form based on combo box 2

Top