Form/SubForm

[Guest]

Two tables - one has location addresses and loan numbers, the other has
banks. The loans have to be associated with a particular bank. One to many
- banks to loans. I need the user to use a form to enter a new property
address and in the process select which bank originated the loan.

I cant seem to figure out how to get a form to work for this. Any
suggestions, given I dont know any access vba at all and have to use the
wizard?

--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141

 

[Charles Calvert]

Two tables - one has location addresses and loan numbers, the other has
banks. The loans have to be associated with a particular bank. One to many
- banks to loans. I need the user to use a form to enter a new property
address and in the process select which bank originated the loan.

Assuming that they can select from a list of bank names, you could use
a combobox with the Row Source Type set to "Table/Query" and the Row
Source set to "SELECT id, name FROM banks ORDER BY name" or something
similar. You'd then set Column Count to 2, Column Widths to 0";1" to
hide the first column and Bound Column to 1.

Make the datasource of the combo the field that holds the foreign key
to the banks table (presumably the "id" field from banks) and you're
done.

 

[Guest]

Thanks - much simpler than what I was trying!
--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141