Passing Value of Selected record to Other Form

[abusaif]

Good Morning Friends,



I have a form "frmdataEntry" & "frmItemMaster (Searchable Split Form)". What I want to do is, on frmDataEntry, txtItem.Setfocus trigger to load frmItemMaster there I search for the item and once the item is found, pass its value to frmDataEntry.txtSearch. and also if the value is not found I could enter a new record to frmItemMaster and pass the value to frmDataEntry.

I hope you guys understood what I mean. Kindly guide me to the links if those are already discussed and solved.

[ranman256]

you have it backwards.
when frmItemMaster is open, pick a record, THEN open frmDataEntry.

select the items on the form record, then click a button to open to that record:
docmd.openform "frmDataEntry",,,"[id]=" & me.txtID

it you want a new record, click NEW record button to:
docmd.openform "frmDataEntry",,,,acFormAdd

[abusaif]

Thanks Bro for your kind response. The problem which I was facing is solved with Split Form and the code I used is "[Forms]![frmDailyReceived].[Item].Value = Me.ID". Now only thing bothering me is the form size with popup. It opens expanded and covering the whole screen and sometimes it opens even wider.

Any Suggestion ??

[ItsMe]

When the pop-up form is open, you should be able to resize it by grabbing the lower right hand corner of the form. Afterwards, use the save icon on the Access Ribbon. There is a width property on the form that can be adjusted during Design View but I do not believe there is a height property. If you are not using the Overlapping Windows + No Tabs option in your database, you will need to make and save the adjustment during Form View.