Predifined value

R

Raul Sousa

I have form with the fields: code, qtt and price.
I want price to have a predefined value.
This value must come from the table Prices, which has the fields: code and
price.
I thought of having:
= [Prices]![Price]

It is not working. I can not understand why.
 
R

Raul Sousa

Jeff
Thank you for your reply.
the form name is fsale and its data source is the table tsale.
tsale has the fields code, qtt and price.
i want the field price from fsale to "pick up" the predefined value from
table prices, and "put" in table tsale.


"Jeff Boyce" escreveu:
Raul

Does your form have a data source? It sounds like you are trying to set a
value for your [Price] control, but maybe the form has no underlying source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


Raul Sousa said:
I have form with the fields: code, qtt and price.
I want price to have a predefined value.
This value must come from the table Prices, which has the fields: code and
price.
I thought of having:
= [Prices]![Price]

It is not working. I can not understand why.
Click to expand...
Click to expand...
 
J

Jeff Boyce

Raul

How does the form know which "price" to use?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Raul Sousa said:
Jeff
Thank you for your reply.
the form name is fsale and its data source is the table tsale.
tsale has the fields code, qtt and price.
i want the field price from fsale to "pick up" the predefined value from
table prices, and "put" in table tsale.


"Jeff Boyce" escreveu:
Raul

Does your form have a data source? It sounds like you are trying to set a
value for your [Price] control, but maybe the form has no underlying source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


Raul Sousa said:
I have form with the fields: code, qtt and price.
I want price to have a predefined value.
This value must come from the table Prices, which has the fields: code and
price.
I thought of having:
= [Prices]![Price]

It is not working. I can not understand why.
Click to expand...
Click to expand...
Click to expand...
 
R

Raul Sousa

indeed.
I dont know.
but ... there must be a way to do this.

"Jeff Boyce" escreveu:
Raul

How does the form know which "price" to use?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Raul Sousa said:
Jeff
Thank you for your reply.
the form name is fsale and its data source is the table tsale.
tsale has the fields code, qtt and price.
i want the field price from fsale to "pick up" the predefined value from
table prices, and "put" in table tsale.


"Jeff Boyce" escreveu:
Raul

Does your form have a data source? It sounds like you are trying to set a
value for your [Price] control, but maybe the form has no underlying source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


I have form with the fields: code, qtt and price.
I want price to have a predefined value.
This value must come from the table Prices, which has the fields: code and
price.
I thought of having:
= [Prices]![Price]

It is not working. I can not understand why.
Click to expand...
Click to expand...
Click to expand...
 
J

Jeff Boyce

Raul

If your price table holds multiple records, you will have to (have the form)
specify which one to use. How do YOU know which one?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Raul Sousa said:
indeed.
I dont know.
but ... there must be a way to do this.

"Jeff Boyce" escreveu:
Raul

How does the form know which "price" to use?


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Raul Sousa said:
Jeff
Thank you for your reply.
the form name is fsale and its data source is the table tsale.
tsale has the fields code, qtt and price.
i want the field price from fsale to "pick up" the predefined value from
table prices, and "put" in table tsale.


"Jeff Boyce" escreveu:

Raul

Does your form have a data source? It sounds like you are trying to
Click to expand...
set
a
value for your [Price] control, but maybe the form has no underlying source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


I have form with the fields: code, qtt and price.
I want price to have a predefined value.
This value must come from the table Prices, which has the fields:
Click to expand...
code
and
price.
I thought of having:
= [Prices]![Price]

It is not working. I can not understand why.
Click to expand...
Click to expand...
Click to expand...
 
Top