dialog box

[indhu]

hi all,

help me
i ve person name repeated so many times in my table. while loading the form i want a dialog box has to open and i ve to enter a name on that. then it has to display all details abt her work. is this possible.

suggestion and help with codes yeah

[MMcCarthy]

hi all,

help me
i ve person name repeated so many times in my table. while loading the form i want a dialog box has to open and i ve to enter a name on that. then it has to display all details abt her work. is this possible.

suggestion and help with codes yeah

All you need is a form based on the table showing all records.

Another form with a combobox (cboUsers) listing all users with a unique id (PK of the table ideally) field hidden.

Then behind a command button (cmdFindUser) put the following code:

 
Private Sub cmdFindUser()
 
  DoCmd.OpenForm "First Form Name", , , "[UserID]=" & Me.cboUsers
 
End Sub
 
 

[indhu]

All you need is a form based on the table showing all records.

Another form with a combobox (cboUsers) listing all users with a unique id (PK of the table ideally) field hidden.

Then behind a command button (cmdFindUser) put the following code:

 
Private Sub cmdFindUser()
 
  DoCmd.OpenForm "First Form Name", , , "[UserID]=" & Me.cboUsers
 
End Sub
 
 

this master form showing all the details. there i placed the command-

cmdfinduser.

and create seperate form with combobox. then i placed the code behind the

command-cmdfinduser


Private Sub cmdFindUser_click()

DoCmd.OpenForm "searchuser", , , "[Person]=" & Me.cbouser

End Sub

compile error is coming. method or datamember not found

pls help and sort out the problem yeah

[indhu]

this master form showing all the details. there i placed the command-

cmdfinduser.

and create seperate form with combobox. then i placed the code behind the

command-cmdfinduser


Private Sub cmdFindUser_click()

DoCmd.OpenForm "searchuser", , , "[Person]=" & Me.cbouser

End Sub

compile error is coming. method or datamember not found

pls help and sort out the problem yeah

its working now..

i ve placed the cmd in searchuser form. and i ve given ID.

thank u

[indhu]

its working now..

i ve placed the cmd in searchuser form. and i ve given ID.

thank u

hi its working but only detail is coming at a time
since i ve repeated names in my table. when i enter name as"pinky" in the combo it should display all the work he did. how to do that.

help me

[MMcCarthy]

hi its working but only detail is coming at a time
since i ve repeated names in my table. when i enter name as"pinky" in the combo it should display all the work he did. how to do that.

help me

You've repeated the names but only one UserID

If you want to go back to using the name you just need to surround it with single quotes designating text as follows:

DoCmd.OpenForm "searchuser", , , "[Person]='" & Me.cbouser & "'"