Re: Can't see choices in Subform wizard

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

neil.mclean@xxxxxxxxxxxx wrote:
> When creating Subforms the Wizard asks if I want to choose from a
> list. As the table names are long the I can't see the choices
> properly.
> e.g. Show tblMeetingdetails for each record in tblCawse Details using
> ??????. How can I see the bit hidden by the scrollbar? Something like
> F2 does for the SQL code

So drop the wizard. Build both forms and then drag the one you want for the
subform from the db window into the design view of the one you want for the
parent. Set the MasterLink and ChildLink properties on the subsequent subform
control as required and you're there.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Re: Form from three diff tables?
    ... This is a little to complex for the wizard, but you can do it yourself. ... Demographics and subformA. ... just click and drag the subform onto your main form. ... with referential integrity enforced and cascade updates ...
    (microsoft.public.access.forms)
  • Re: Selecting a record in a list box
    ... If you have wizards turned on, add a combo box to your form and tell the combo box wizard that you want this combo box to "find a record on my form". ... The first text box, LoanNo, is the basis for the other 3 text boxes, ... ' Find the record that matches the control. ... You've set up your subform incorrectly. ...
    (microsoft.public.access.forms)
  • Re: difficulty with a relationship/subform
    ... automatic linkage that the Wizards perform when building forms/subforms. ... you need to do to make it easy id create the form and subform, ... form in Design View and use the subform tool in the design toolbox to add a ... The wizard will take you through the rest. ...
    (microsoft.public.access.forms)
  • Re: New Wine in Old Bottles problem (never use an old form on a new table schema / architecture)
    ... A "whitened-out" subform is a sure sign that you got it's RecordSource wrong ... set up a compound key--but I used the Wizard again afresh on the clean ... not unlike a unicyclist thinking a unicycle is easy to drive. ...
    (microsoft.public.access.formscoding)
  • Re: Form Problems- First uneditable, now finds no records?
    ... Create a new form, WITHOUT using a wizard ... >subform link. ... As far as I can see, if the magic VBA code in ... >the master form gets lost you would have to create ...
    (microsoft.public.access.gettingstarted)