Hi Peter,
Your advice to use semicolon was successful for the criteria, that was
now accepted. However, the main problem remains. Now, though, nothing
is displayed in the second combobox.
Many thanks for your invitation to send you data. However, I do not
know how to furnish you with data and what you need for helping me. My
test.mdb is only 244 kb so it is easy to send but to what address?
Attachments seem not to be allowed here.
Best regards
Ove
--- In [EMAIL PROTECTED], "phoogenb" <[EMAIL PROTECTED]> wrote:
>
> Hi Ove,
>
> I think it may be because formula arguments need to be separated
> with semicolons (;) for locales with a decimal comma (like most of
> the non-English-speaking world, including Sweden).
>
> So instead of IIf(Arg1, Arg2, Arg3) use IIf(Arg1; Arg2; Arg3).
>
> I'm not very well familiar with the Northwind examples. If that
> doesn't work, try posting the SQL here. I will have a look at it
> (if someone else doesn't get to it before I do).
>
> Good luck,
>
> Peter
>
> --- In [EMAIL PROTECTED], "Ove Billing" <oy@> wrote:
> >
> > Thanks Peter for your suggestions.
> > I have tested the method given in kb 209576 but have failed. Your
> first mentioned method and the one given by Jackie Home are too
> general for me but the kb being more detailed was easier.
> > After having typed everything correct in my Swedish edition of
> Northwind and Acc2000 and thus no error messages appeard any more
> the result was that all Rooms appeared in the the second cbo
> irrespective of the setting in cboHouse. I tested both with my own
> tables and with those in Northwind with equal result.
> > Under 3. in the kb a Criteria is given that seems to be incorrect.
> With both bases I get an error message that tells me that the comma
> at the end of the first line is not correct (when trying to save the
> query the message comes and the comma is marked. On the other hand
> the criteria is, I guess, not essential for the end result, only a
> way to take care of the situation when nothing is selected in cbo1.
> > Do you have any comments on this or could you possibly suggest
> another method in some detail, being possible for me use?
> > Best regards
> > Ove
> >
> > ----- Original Message -----
> > From: phoogenb
> > To: [EMAIL PROTECTED]
> > Sent: Wednesday, April 11, 2007 4:45 PM
> > Subject: [ms_access] Re: Form design with choosen records
> >
> >
> > Hi Ove,
> >
> > One possible solution: A form displaying tblHouse records, and
> > containing a subform showing tblRoom records. If you set it up
> > properly, Access will handle the filtering of the subform
> automatically.
> >
> > Something else that might be of use: A pair of combo boxes,
> where the
> > user selects a house in the first one, and then the second one
> shows
> > only those rooms that belong to the chosen house. There's a
> > description of how to do this in the MS Knowledge base ("How to
> Create
> > Synchronized Combo Boxes"):
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;209576
> >
> > Good luck,
> >
> > Peter Hoogenboom
> >
> > --- In [EMAIL PROTECTED], "Ove Billing" <oy@> wrote:
> > >
> > > I am not very skilled at Access but try anyway to help a small
> local
> > > museum to erect a base with their objects.
> > > One problem to handle (with simplified examples): I think of
> having a
> > > tblHouse with 4 records (H1, H2, H3 and H4) and a tblRoom with
> many
> > > rooms (R1, R2 ...), some in H1, others in H2 etc. How do I
> construct a
> > > form where only rooms in H1 are visible or choosable when first
> > > choosing H1 etc. ? Is this possible? Other ways?
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
