Re: Open Form, based on a table, to specific record from another form



There are several ways to achieve what you want and you are using one of them.
Why not put a MsgBox in your next form and see what you are looking up?

MsgBox Str(Nz(Forms!SWITCHBOARD.LoanSelect,0))




Markus_989 wrote:
On Apr 29, 3:36 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:
Is [LoanID] a number or a string?

[quoted text clipped - 31 lines]

- Show quoted text -

[LoanID] is an Autonumber from the LOANS table.

--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

.



Relevant Pages