passing parameters in access

Question

It's been awhile since I have worked with access but I have 2 forms, formA and formB. All I want to do is pass 1 value from formA  to be used in the sql query of formB.

Answer 1

There are many ways. The exact one depends on the finer points of your requirements. Since we don't know those, here is a simple one:
Create the query for formB. In the criteria for some field write:
Forms!formA!someControlOnFormA

---

-Tom. Microsoft Access MVP

Answer 2

Hi,

If FormA is open when you open FormB, then you can simply reference FormA. For example:

Forms!FormA.TextboxName

Hope it helps...