Grid on form

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

Greetings,
I am creating a subform to be place in another form.
I want a grid to appear on the form and contain table data.

How do you place a grid on the form ?

thanks,
-D
 
Set up a form with the labels above the controls, so that the controls span
left to right in a single row across the form. Drag the form footer or
bottom of the form to directly below the data textboxes. In the form's
properties>> Format tab >> Default View, select Continuous Forms.
Your labels will be across the top above the data, and the records will list
in rows below, similar to an excel spreadsheet or table layout.
 
I must be eating "stupid" pills today.

I can't quite get the form - subform relationship working.
Table 1
memberid (Primary key)
otherfields.

Table2
memberid (field in table).

Created a form.
Put a listbox on the form. When placing the listbox answer the wizard's
questions and
select the table fields I want show.

Create a form (which will be a subform). Do like your previous posting.
Drag and drop the subform I created into form1.

Select subform and choose properties. Can't use the build child link or
master link
"Can't build a link between unbound forms". If I type in memberid in child
link and memberid
in the master link, it still doesn't work.

Definition of doesn't work:
Click on entry in listbox, doesn't cause records from table2 to display in
the subform (records from table2 that have the same memberid as the record
selected in listbox).

-D
 
Is the same table/field part of the source for both forms? If not, you will
need to work out a way to manage this, in order to create the master/child
links.
 
Table1 contains records for members (memberid, name,etc).
Table2 contains transactions for the members (trannum,memberid,trandate,
etc).

In the listbox I want all the members to appear. When the user clicks on a
user name
in the listbox, I want a grid on the right to show all the transactions for
that member.

So, the linking field between table1 and table2 is memberid. I haven't
created a "relationship"
(1 to many) between the tables. I thought by specifying the child link and
master link fields as
memberid I would be ok.

What am I missing ?
 
No, the relationship must be defined in order to link the fields. I bet once
you do this it will be fine

;-)

SusanV
 
thanks for the help. Still cludgy and doesn't work quite right.
Everything I've read says drag-n-drop and all is well.
When I drop a subform on a main form, it NEVER builds the child/master
links.
When I click the wizard (...) it says "Can't build a link between unbound
forms".
If I assign a data source to my main form (which doesn't have any controls
other than
2 subforms), then it works but since the main form does not cycle through
the records,
the subreport sticks on the first record of table2.

Ready to scream now.

Even tried a listbox on the main form and then the detail sub form. When I
click on a record in the listbox,
the detail doesn't show.

A tutorial probably would help.
-D
 
I feel your pain Darryl, been there believe me! I ran into the EXACT same
thing you are on my first project.
Then one day when my head hurt from running it into the wall I realized -
instead of using 2 subforms, use ONE as the main form and make it bigger to
accommodate the second one as a subform to that one. Make sure both forms
are related and you should be good to go.

It can be frustrating for sure, but you'll get it working!

;-)
 
Back
Top