Re: if statements in queries

Maybe. Design a simple form - no data source. Put a control on it - make it
a combobox. Set the data source of the combobox to a Table/Query and design
a query in the row source that shows something you would like the user to
select.

Go to the Events tab and make an Exit event that opens the second form. Set
the default value of the control on the second form that you want to the
value of the control on the first form.

Start there and get more complicated.

Bonnie

http://www.dataplus-svc.com

sandpking@xxxxxxxxx wrote:
Maybe I'm making this to difficult. All I want to do is have 2
screens. The first one acts as a filter for the second one. I'm
currently using a query, but if they leave a field blank, the query
won't work right. There is no telling what information the user will
have.

On Jun 23, 1:17 pm, sandpk...@xxxxxxxxx wrote:
I still get the too complex message.  I should have said that I have
Access 2003 and Windows XP SP2
[quoted text clipped - 32 lines]

- Show quoted text -

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200806/1

.

Relevant Pages

  • Re: Control displays "Form View" in status bar instead of description.
    ... Open your form in design view. ... On the Other tab of the Properties box, set the StatusBarText property. ... >I have a ComboBox on a form that displays "Form View" in the status ... > that serves as the ComboBox's control source when it has the focus. ...
    (microsoft.public.access.formscoding)
  • Re: Simple question about bound combobox at update
    ... I removed that integer column and replaced with a combobox by dragging ... "Use data bound items" and the for data source used ... with sensible value and display members. ... even if the control does have values in the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: drop-down menus
    ... You've described exactly the functionality of both a listbox and a combobox. ... With your form in design view, use the wizard to help you create the ... control. ...
    (microsoft.public.access.forms)
  • Re: Easy Question on Dynamically created Control
    ... then assign a new binding context to the control ... // Set the data source. ... but different data sources for each control (the data view ensures ... > ComboBox x = new ComboBox; ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: GUI Issue: Controls are NOT visible when .Visible = TRUE
    ... the same control every time. ... In each case the control is either a textbox, ComboBox or Date control In ... The problem is that at runtime (design or compiled mode) when the form ...
    (microsoft.public.vb.controls)