please help getting hyperlink to open subform...

[joebaich]

i accidentally got it to display "yes" and "no"

[June7]

Some of the A_J_R records in Servicing can be Yes and some 0 and you want whichever shows on the FolioDetails form? Then use the multiple criteria example.

If you want Yes or No, options are a Yes/No field or a text field storing text 'Yes' or 'No'. In either case, the control can be a combobox that limits to the two choices.

Need to know how 0 gets populated before can offer solution.

[joebaich]

Wow, it almost all works now! The only thing left to fix is how to i get the servicing form to show multiple records when there are multiple records for that A_J_R in the servicing table? Currently it is only showing the first instance.

Thanks a million!
Joe

[joebaich]

ok, just noticed a little toggle button at the bottom where i can scroll through the records... can i get this into a data sheet style so i can see them all on one page? when i made the form with the form maker wizard thing i picked datasheet style... and it gave me vertical headings instead of horizontal ones?

[June7]

Yes/No or text field - either can be bound to a text or combo box. With a combobox you can better control what the user enters. Use of delimiters depends on field type.

[June7]

Not sure what you mean be vertical headings. Datasheet view can show headings only one way.

Set the form as Continuous or Datasheet. Continuous view can be made to look like Datasheet. If you created form with wizard then the controls are probably all 'grouped'. Select all the controls, right click > Layout > Remove. Now you can rearrange and resize all the controls as you wish.

[joebaich]

Hey June, thanks for all the help! the last piece of the puzzle seems to be this form... i'm not sure what the issue is here, when i created the form, i used the data sheet layout and i see this layout when i open the form directly, but when i open the form from the expression you provided earlier via a different form, it disiplays my servicing form in a different layout, where it will show data from the table, but only one record per page, and you have to click through pages if there are multiple records. I was hoping this would display the datasheet layout view so that multiple records would show up on one page as multiple lines... I've attached some screen shots below for illustration. Is there some way to get it to display all the records on a single page instead of each record on an individual page?
Thanks, Joe

[June7]

What is the DefaultView property setting? The form might be opening as Continuous and all the extra space is because of the size of the Detail section. If it is set as Single then the size of Detail section is irrelevant. However, opening from either method the form should open by the DefaultView setting unless code modifies it.