Recent content by sud2017

Would appreciate any help with my question. User will only see Main form and enter the value in a text box and I want the number to goto the subform. Vice versa, I also want the output of subform to appear in a textbox of main form. Any help would be greatly appreciated.

Noted. Thanks for the link. I was unaware of it and quite frankly I was in rush to get my answer. I am deleting my post on the other forum. Sorry!

The data in main form has no relation to the data in subform. Main form data will be entered by the end user. I want this data to goto the subform, where the subform will perform some calculations.

Hi All, I want to pass a value (number) from one form (main form) to a subform. These values are in Text Boxes. How could I do that? Your help and time will be greatly appreciated. Thanks!

Got it. Sorry for the confusion on above code which is wrong. I'm simply using insert hyperlink tool from Access now.

Thanks for the directions. I tried this code on a command button to open up the excel file but its not opening up the file. Further guidance will be much appreciated. Private Sub CmdOpenAttach_Click() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone OpenFirstAttachmentAsTempFile...

Hi Guys, Need help on my form: Q1: I have created a FORM that allows me to perform cost estimation for different opportunities my company quote for. I want a command button in my form that would open up an external WORD document from our network directory. How can I do this? Q2: Is it...

Plog and Mark, Understood. It was a quick fix. I based my form on a single table now rather than a QUERY and I can retrieve existing records and enter new records as well. Thanks very much for your help.

Hi Guys, I have created a simple form that is based on a QUERY which contains fields from 2 tables. These 2 tables have 1-to-many relationship. Intended purpose of this form is to perform cost estimation for various opportunities in my company. I want this form to show existing records (item...