Criteria for opening form from a different subform

[Crystal (strive4peace)]

Hi Scott,

"everything works fine"

great!

"Do I need code?"

I don't think so.

"but the cbo is empty when I change records and stays empty."

.... it sounds like perhaps you don't have ControlSource
specified...

Please tell me the following properties for your combobox:

ControlSource
RowSource
ColumnCount
ColumnWidths
Listwidth


Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

 

[Scott_Brasted via AccessMonster.com]

Never mind, I figured it out. Thank you VERY much for teaching all this. It
has been a real eye opener. I am now reading your site. Learn , learn , learn.


All my best,
Scott

p.s. Took ALL captions out! Working on multi-table forms now. Lots of cbos

Hi Scott,

I see you got rid of the default values for numeric foreign
keys <smile>

In my opinion, it is best not to use Captions in the table
design -- the only people who should open tables directly
are administrators and they need to see the real fieldnames,
not captions

Do be sure to fill out the field Descriptions in your table
designs -- these are used for StatusBarText when you created
forms.

you still have forms based on multiple tables -- if you plan
to edit data, your should not do this

in frmViewDonor, do not pull Position information into the
RecordSource -- this can be shown using a combobox.

Because qryViewDonor gets all fields from both Contributors
and PositionList, you are only going to see records where
PositionID is filled out. Here is what you see for your
current sql:

SELECT tblContributors.*
, ([DonorFirstName] & " " & [DonorLastName]) AS DonorName
, ([City] & ", " & [StateorProvince] & " " & [PostalCode])
AS CSZ
, tblContributors.DonorLastName
, tblPositionList.*
FROM tblPositionList
INNER JOIN tblContributors
ON tblPositionList.Position_ID = tblContributors.PositionID
ORDER BY tblContributors.DonorLastName;

Donor First Name
Diane
Scott
Karen
Mary
Luci
Claire
June
Amy
Linda

by changing the Join Type to show all records from
Contributors even if a matching record is not found in
PositionList, the FROM clause of the sql now is:

FROM tblPositionList
RIGHT JOIN tblContributors
ON tblPositionList.Position_ID = tblContributors.PositionID

and we now see 20 records:

Donor First Name
Diane
Scott
Jackson
Karen
William
Mary
James
Joyce Ann
Mary Ellen
Gaston
Willy
Luci
Claire
June
Bill
Sara
James
Sam
Amy
Linda

... but, as I said, you should not be pulling the
tblPositionList table into the RecordSource for this form anyway

It doesn't even look like you are using any fields from
PositionList on your form. The combobox for PositionID can
use PositionList as a RowSource withOUT it being in the form
RecordSource

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

Good morning Crystal,

[quoted text clipped - 97 lines]

 

[Crystal (strive4peace)]

you're welcome, Scott happy to help

"I am now reading your site. Learn , learn , learn ... Took
ALL captions out! Working on multi-table forms now. Lots of
cbos"

great and great! I am currently adding a Whistles and Bells
section to my site... so keep checking back till items
listed are done. The index lists stuff I plan to add pages for.

Whistles and Bells
http://www.accessmvp.com/Strive4Peace/Whistle

I have an example finished with code called Sort123, which
enables the user to easily sort by any column in a
Continuous form by clicking on the column header.

Now I am working on a page called BoldMe to demonstrate how
you can boldface a label if the checkbox is true, or
boldface the label of the selected option in a frame.

Once the items listed are done, I will probably add more ...
or maybe I'll finish another video -- who knows. Depends
which way the wind blows

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*