Navigation Form - Main Form buttons - Problem with Query (1 Viewer)

Surka

IT dude
Local time
Yesterday, 21:03
Joined
Aug 5, 2013
Messages
41
So I have made all the necessary forms to start working with my Access, and now I need a main form, a home where I should put all the buttons to enter each form.

What do you suggest?

I have used the Navigation Control on a New form (http://msdn.microsoft.com/en-gb/library/ff851947(v=office.14).aspx).

A row with buttons appeared, and I complete the property: Navigation Target Name with the target form, but it is giving me some trouble with a searchForm and a Query. Every time I enter this form (using nav control), Query asks for an Input.

How can I fix this?

Thanks
 

Surka

IT dude
Local time
Yesterday, 21:03
Joined
Aug 5, 2013
Messages
41
Any help on this? It seems to be a problem like when you have a path issue.

Because the search form as a subform of the Navigation form (main form) pop up a message asking for data for the Query.

But the same searchForm, opening directly, works.
 

Surka

IT dude
Local time
Yesterday, 21:03
Joined
Aug 5, 2013
Messages
41
GOT THE ANSWER:

On Access 2007:

I was trying to get the value from a Form on a Subfrom this ways:

Like "*" & [Forms]![MainForm]![NavigationSubform].[Forms]![formSearch]![txtSearch] & "*"

But the Query keep asking for an input.

And all the different ways: With point and !, "Form" with S and without S. Because I read, that in order to get value of a TextBox, inside a Form, and this Form inside a Subform, you have to call it level by level.

But the answer was:

Like "*" & [Forms]![MainForm]![Subform]![txtSearch] & "*"

:mad:
 

Users who are viewing this thread

Top Bottom