Creating a sub form

[Will 1960]

When i try create a sub form on an existing for using the wizard, the selection of tables and queries appear but there is no detail showing in any of my queries. There is data showing if a try to use a table.

[aytee111]

Make sure they are SELECT - not update - queries.

[ranman256]

Check the parent form query. (See it run)
check the child form query.
and make sure the sub form is connected via properties:
link parent field
link child field.

[Will 1960]

Sorry Gents I cant even get that far in. The wizard wont let me create the subform because I need to select the fields I want to include but they don't show in the wizard box.
Any other ideas.
The query isn't an update query.

[aytee111]

Use the form wizard to create a new form, then add it to the main form as an existing form.

[Will 1960]

Another thing to note. All of my queries appear like this. I cant make a subform or report from any of them.

[Will 1960]

Already tried aytee111. Still the same

[aytee111]

There is something wrong with your Access installation. You will have to create the form manually, without using the wizard. Or try re-installing/repairing Access.

[aytee111]

I take it that your queries all run successfully!

[Will 1960]

Yes they do. I don't there is a problem with Access. It is something unique to the queries I am raising.

[aytee111]

If you create a query such as "SELECT * FROM TableName;" are you able to create a subform from that?

[Will 1960]

For anyone out there who is interested in this thread, I have created a new query and that shows the fields I can select so whatever is causing the problem is related to something I have done whilst I have been working today. I just don't know what.

[Will 1960]

Sorry aytee111 our messages must have crossed.

[Will 1960]

As I said, any queries I am creating from now are fine and I can turn them into subforms. It is all my other queries which are the problem.