Form , Text Box , Pop Up Form

[amal2004]

I really do appreciate any help.

Hello

I am trying to create a form in access 2000 with a text box and a button. When you enter a value in the text box like ID Number and click the “Get” button, I need another form to pop up with the info related to that ID..

The Table that i have this info in is called Tbl_Main, the columns that i have in it are
[ID] [Full Name] [SSN] [Group Policy].....
AAB Tom Malmax 235232 10236
So what i would like to do is to enter the ID in the first form and hit the Button...A pop up form should come out with the ID and all related fields in the Pop up Form. Just for users to see in a fast manner....

 

[TheAceMan1]

How are ya amal2004 . . . . .

Just a suggestion. I'm sure you have your reasons for the two forms.

Since you have to open a form anyway, why not base a [purple]single form[/purple] on the table and have a [blue]ListBox[/blue] or [blue]ComboBox[/blue] that will take you to the selected record?

You could do it all with the wizards!

See Ya! . . . . . .

 

[Darrylles]

Hi,

You will come back with further questions .....

Paint all of your fields on there (textboxes etc)

Make your [ID] field control a combo. (call it cmbID)

Make the cmbID recordsource = "select ID, [Full Name], SSN, [Group Policy] etc.... from tbl_Main order by whatever;

Full Name textbox = txtFullName
SSN textbox = txtSSNName etc etc

For all controls, make their recordsource = to the combo (dependant on their position in the combo).

e.g. in each RecordSource property (of each textbox):

txtFullName RecordSource property = "cmbID.column(2)"
txtSSN RecordSource property = "cmbID .column(3)"
etc... for each textbox etc.

Each textbox will then get it's value from cmbID dependant on it's column number within cmbID.


ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk