Predifined value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...
 
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...
 
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...
 
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...
 
Back
Top