Pop Up Form

[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

 

[Guest]

Add to your DoCmd a WhereCondition: "[name] = '" & txtName.value & "'"
or whatever the relevant fields/controls are called.

 

[sanndipannandyi]

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.

[quoted text clipped - 8 lines]

Sandipan

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

 

[Guest]

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.

 

[sanndipannandyi]

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.

Sir I replace the txtName.value with [Name] but record of Main form and Pop
Up Form. Plz Sir help me .I confused.

 

[sanndipannandyi via AccessMonster.com]

Sir plz I am waiting for your answer.

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

[quoted text clipped - 4 lines]

Hope that helps.

Sir I replace the txtName.value with [Name] but record of Main form and Pop
Up Form. Plz Sir help me .I confused.