Beware
09-25-2005, 04:32 AM
Hello before I ask the question I will short introduce myself:
I am a new member here on this forum. 31 years of age and new user from MS Access. For a project I have to use MS Access. I earn my money as a software engineer but I am used to work with Intersystem databases.
My question is the following:
I tried to insert a value in a textbox which was generated with a SELECT query. The QUERY on its own works like a charm but if i try to insert the outcomming value in a textbox with SetValue([Query]![Field]) i get a object error.
SetValue():
Item: [Forms]![Tabel]![Field]
Expression: [Query]![Field]
How do I get a value from a Query in a textbox without using VB?
Greets Ben
I am a new member here on this forum. 31 years of age and new user from MS Access. For a project I have to use MS Access. I earn my money as a software engineer but I am used to work with Intersystem databases.
My question is the following:
I tried to insert a value in a textbox which was generated with a SELECT query. The QUERY on its own works like a charm but if i try to insert the outcomming value in a textbox with SetValue([Query]![Field]) i get a object error.
SetValue():
Item: [Forms]![Tabel]![Field]
Expression: [Query]![Field]
How do I get a value from a Query in a textbox without using VB?
Greets Ben