Hi Art,
> Now the issue is when a record does not exist. It does not pass the InspectionId from the Inspections form.
Once you open the Form in the Macro make sure you have not yet removed the TempVar.
In the Macro:
SetProperty
Control Name InspectionID
Property Value
Value =[TempVars]![Inspection_ID]
Include the "=" in the Value box.
Kind Regards,
Pat Wood
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers:
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini wrote:
>
> I solved the existing record issue. I took out the form name in the where clause:
> Â
> If IsNull(InspectionID) then
> Â 'Open the form to a new record if current ID is null
> Â OnError(Fail,)
> Â Open Form
>     Form name LotsGroundsDetail
> Â Where Condition
> Â Â Â Data mOde Add
> Â Window Mode Dialog
> Â Requery()
> Else
> Â 'Use a TempVar to pass a filter to the OpenForm
> Â SetTempVar
>    Name  Inspection_ID
> Â Â Â Expression = InspectionID
> Â On Error (fail,)
> Â Open Form
> Â Â Â Â Form name LotsGroundDetail
> Â Â Â Â Where Condition = InspectionID=TempVars!Inspection_ID
> Â Â Â Â Â Data Mode Edit
> Â Â Â Â Window Mode Dialog
> Â RemoveTempVar
> Â Â Â Â NAme Inspection_ID
> Â Â Requery
> Â Â Â Â Control Name
> Â End if
> Â
> Â
> Now the issue is when a record does not exist. It does not pass the InspectionId from the Inspections form.
> Â
> I use to be able to do it with OpenArgs but I don't know how to do with a Macro.
> Any ideas?
>
> With Warm Regards,
>
> Arthur D. Lorenzini
> IT System Manager
> Cheyenne River Housing Authority
> Wk.(605)964-4265Â Ext. 130
> Fax (605)964-1070
> alorenzini@...
> “Only those who will risk going too far can possibly find out how far one can go.â€
>
>
> ________________________________
> From: patrickawood
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, January 30, 2013 8:50 PM
> Subject: [MS_AccessPros] Re: Issue passing InspectionID from one dialog form to another using a macro.
>
>
> Â
>
> Hi Art,
>
> I wonder if in your Macro could it be that you are removing the TempVar Inspection_ID too soon. Have you tried to remove the TempVar after using Requery?
>
> Kind Regards,
> Pat Wood
> Gaining Access Technologies Founder
> http://gainingaccess.net
> Microsoft Access and SQL Azure Information Center for Developers:
> http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx
>
> --- In mailto:MS_Access_Professionals%40yahoogroups.com, "Art" wrote:
> >
> > I am getting a automation error when I try to pass a ID value from on dialog form to another in a web form. I have uploaded a document which contains snapshots of the process. Any ideas wouold be great.
> >
> > Thank you
> >
> > Art Lorenzini
> > Sioux Falls, SD
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar