Please help me

[scrye]

Hi
First I want to excuse you about my English.
I have a problem -
I have a query in subform of some form and in the form there is a
textbox
i want when i select a record from the query the textbox to be fill
aoutomatic
Please help me
thank you
Marieta

 

[geebee]

hi,

Your question is somewhat vague, but I will do the best I can...
You can use a Dllookup("[table_column_name]",
"tbl_name","[table_column_name] = [form_field_value]")

Remember, if you want the subform to refresh based on a value put in the
main form, Access does not commit (SAVE) a record until you move to the next
record. So you could simulate moving to the next record to refresh, or just
put a Refresh button in your main form.

Let me know if you need further help.

Hope this helps.


geebee

 

[scrye]

Thank you very much Geebe
but i have a problem again
i did this you told me but in textbox is dispayed just #Name?
geebee напиÑа:

hi,

Your question is somewhat vague, but I will do the best I can...
You can use a Dllookup("[table_column_name]",
"tbl_name","[table_column_name] = [form_field_value]")

Remember, if you want the subform to refresh based on a value put in the
main form, Access does not commit (SAVE) a record until you move to the next
record. So you could simulate moving to the next record to refresh, or just
put a Refresh button in your main form.

Let me know if you need further help.

Hope this helps.


geebee

Hi
First I want to excuse you about my English.
I have a problem -
I have a query in subform of some form and in the form there is a
textbox
i want when i select a record from the query the textbox to be fill
aoutomatic
Please help me
thank you
Marieta

 

[geebee]

Could you post a sample of your database, so I can better understand what is
going on?

Thank you very much Geebe
but i have a problem again
i did this you told me but in textbox is dispayed just #Name?
geebee напиÑа:

hi,

Your question is somewhat vague, but I will do the best I can...
You can use a Dllookup("[table_column_name]",
"tbl_name","[table_column_name] = [form_field_value]")

Remember, if you want the subform to refresh based on a value put in the
main form, Access does not commit (SAVE) a record until you move to the next
record. So you could simulate moving to the next record to refresh, or just
put a Refresh button in your main form.

Let me know if you need further help.

Hope this helps.


geebee

Hi
First I want to excuse you about my English.
I have a problem -
I have a query in subform of some form and in the form there is a
textbox
i want when i select a record from the query the textbox to be fill
aoutomatic
Please help me
thank you
Marieta