Pop Up Form

  • Thread starter Thread starter sanndipannandyi
  • Start date Start date
S

sanndipannandyi

I make one data base on access for my company. But I face one problem in pop
up form. I want that pop form should be show the same record of the main form.
For example if main form shows the record of Mr.X & when I will click the
comand botton for pop up form (suppose Leave Record) it should show the
record of Mr.X & same for Mr.Y ,MyZ etc.

Plz help me immediatly.
For ur information i put following code in event procedure in command botton.
Call Access.Application.DoCmd.openForm(FormName:="Leave Form",View:=acNormal,
Datamode:=acFormEdit,windowMode:=acDialog.


Sandipan
 
Add to your DoCmd a WhereCondition: "[name] = '" & txtName.value & "'"
or whatever the relevant fields/controls are called.
 
Stwange said:
Add to your DoCmd a WhereCondition: "[name] = '" & txtName.value & "'"
or whatever the relevant fields/controls are called.
I make one data base on access for my company. But I face one problem in pop
up form. I want that pop form should be show the same record of the main form.
Click to expand...
[quoted text clipped - 8 lines]
Sandipan
Click to expand...
Click to expand...
Plz sir explain in details.
My Primary Key is [Name] and I put this in where condition of Macro of this
pop up form "[name] = '" & txtName.value & "'" .But when I click in command
botton one dialog box is comming with command "Enter Parametar Value----
txtName.value.
Plz tell me the next correction steps.
Sandipan
 
You need to replace txtName.value with wherever your primary key is stored on
the first form. Ie. the main form is showing the record of Mr X., where is it
showing the primary key for Mr X? Is it in a text box? If so, replace
txtName.value with whatever your textbox is called (you can even omit the
..value bit). Is it a combobox? Same method. If it is a label, use
<name_of_your_label>.caption.

Hope that helps.
 
Stwange said:
You need to replace txtName.value with wherever your primary key is stored on
the first form. Ie. the main form is showing the record of Mr X., where is it
showing the primary key for Mr X? Is it in a text box? If so, replace
txtName.value with whatever your textbox is called (you can even omit the
.value bit). Is it a combobox? Same method. If it is a label, use
<name_of_your_label>.caption.

Hope that helps.
Click to expand...
Sir I replace the txtName.value with [Name] but record of Main form and Pop
Up Form. Plz Sir help me .I confused.
 
Sir plz I am waiting for your answer.
sanndipannandyi said:
You need to replace txtName.value with wherever your primary key is stored on
the first form. Ie. the main form is showing the record of Mr X., where is it
Click to expand...
[quoted text clipped - 4 lines]
Hope that helps.
Click to expand...
Sir I replace the txtName.value with [Name] but record of Main form and Pop
Up Form. Plz Sir help me .I confused.
Click to expand...
 
Back
Top