View Single Post
  #3  
Old November 5th, 2009, 06:13 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Create form using query doesn't fill fields

On Thu, 5 Nov 2009 07:10:07 -0800, Smoki
wrote:

Hi,
I have question, I want to create form using query. I made a form in which I
choose from one table field, and then the other fields on my form should be
filled in with appropriate row from table.
I already tried query, and it works. But, when I choose one paramether on my
form, and then press command button to refresh form data, nothing happend?
Why???
Maybe it's connected with Primary key? I have Primary key in my table, but I
think if I didn't do something good, in that case even query shouldn't work?!
But, my query works, only I have problem with filling form fields


Sorry, we cannot see your screen from here...

Evidently there is something wrong with the query or with the form. Could you
open the query in SQL view and post the SQL text here? What is the form's
Recordsource property (it should be the name of the query)? Did you perhaps
set the form's Data Entry property to Yes (that will let you add new records
but not display existing ones)?
--

John W. Vinson [MVP]