Search results

Currently, I have a form with tabbed pages in it. The second tab, I have a subform inserted into it. I have a completely separate form that looks through records. I want to be able to click on a record from the separate form and open the Main tabbed form, to the second tabbed page, to a specific...

Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Project_Number = Forms![frm_Main_Data_Entry]![Project_Number] End Sub

nothing happened. I put the info in the popup form for a blank field and it still did not update for that project_number, but it went into its table with no project_number associated with it.

that doesn't seem to work for me. Do you think I should put something like that in my onopen function?

no. the 'main' form it self shows all the info for one project_number. I can click through the record selector below and go to the next project number record. inside this form is a box that shows all of the districts that covers this project. if there is already a district defined, the popup...

I have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be...

Thanks so much. I saw that solution a couple of other places too and just couldn't seem to get it to work. I finally found this, & FormatCurrency(Funds_Committed,0), and it did the trick. Thanks for the help tho

Please help. I have inherited a DB and really need help cleaning it up. I have a Concatenate string of text and currency. When joined together, the currency format disappears. I need to reformat so the string stays together with new format. Below is what I have: Public Function...