How to propogate a CB value to another called form

[asabri]

Folks I am new to Access and I believe this is a very simple question.

Is there an easy way to propogate a value from one form to another?

I have two forms: Form A and Form B
Form A is the main: it contains many field including a Supplier CB.
Form B allows the user to add a new supplier if it is not on the list..

Form A allow user to pick a list from the table of suppliers. I allowed edit ietm list in the properties to add the list of suppliers to grow as new supplier are entered. I pointed the user to Form B ton enter the new supplier.

Things going well as I planed, however it is annoying when I enter the new supplier in Form A and respond "yes" to add new items I have to retype the new supplier in Form B again. I have about 11 fields in Form A that will follow this theme. This will not be user friendly if not fixed.

Any simple idea. I need to port this code to the web later. Staying away from VB is prefered however any suggestion is appreciated.


Thanks.

[NTC]

yes - when in form B one would call a form A value with:

Forms!FormAFormName.FormAfieldname

form A must be opened. So if you want Form B field2 to have this value then it would be:

me.field2 = Forms!FormAFormName.FormAfieldname

Get yourself an Access textbook findable easily at Amazon or any large book store - - all this info can be found there.

Hope it helps.

[asabri]

NTC,
Do you recommend a simple book? I did get ACCESS 2010 Inside out by Jeff Conrad and John L viescas and I think it is an over kill as I am having hard time find simple examples quickly for basic stuff.

[NTC]

Inside Out can be a bit elaborate which makes finding basic stuff a tad difficult - - I agree....

while you won't find it at a bookstore - but probably at Amazon is the book series intended for classrooms; the publisher is Thomson or Thomson Course Technology ...not sure which.

the last I have is called: New Perspectives on Microsoft Office Access 2007

and typically it is a 2 book series. I imagine they published it for 2010.

I think the authors probably change - but for 07 it was
Joseph Adamski
Kathleen Finnegan

because it is classroom oriented - it builds from the basics and has straightforward examples.... but having 2 books doesn't hurt - and it is worth your time if you review both to get the same info from different angles....

hope it helps.

[kbnotes]

Have you checked out Microsoft Access 2010 Step by Step or Microsoft Access 2010 Plain & Simple? Both titles are from Microsoft Press. They are also available for Access 2007.

Thanks,

Kenyon Brown
Senior Editor
O'Reilly Media / Microsoft Press Division