Search results

Oh, one more thing... I realized the VendorID is actually a text value, not a number... how would that code change? See attached revised database Thanks!

Excellent! that code looks very simple and it works! thanks so much

Good morning, see if you can see the attached Database. I simplified it for this purpose. Thanks for all your help!

Hello, When the second form is opened to enter the record of a new contact, the VendorID is not defaulted. I have to manually enter it. The contact form opens and all the contacts are properly filtered though to the corresponding VendorID. Thanks

Sure, sorry about not being clear: In the DB there are 2 Tables: 1) Vendors 2) Contacts Both of them have the field VendorID which links them (1 vendor will have many contacts within their organization - one to many relationship - see capture) Now on the main form for vendors, instead of...

No, it is not working, sorry

Yes, the VendorID already exists in the DataBase. We are adding contacts to that vendor which are linked to the vendor by the same VendorID field

Thanks... I go this far with some VBA (I found this one on the FormsDemo): Dialog window opens but it is not filtered at all with the correct Vendor Private Sub Command78_Click() Const FORMNAME = "Sub_CONTACTS" Const MESSAGETEXT = "No record." Dim strCriteria As String...

Hello, I created a form with vendors which has a button and opens up another form in "dialog ratesheet" format with that vendor's contacts. The button worked well in that it filters the form with the appropiate VendorID but when I need to enter a new contact, I have to manually enter the...

I still cannot get the delimeter right. WOuld it be something like this? Private Sub ServiceNameID_AfterUpdate() Me![Price] = DLookup("Price", "Services", "[ServiceNameID] = 'Me![ServiceNameID]'") End Sub

Thanks, Paul, yes I see your point... basically I do not need to populate all the other fields on to the "OrderDetails"

Hi Paul, It is Short Text.

The objective is to populate the "OrderDetails" form / table with data from the "Services" & "Items" table. I am able get data from the "Items" table with the below event: Private Sub ItemID_AfterUpdate() Me![Brand] = DLookup("Brand", "Items", "[ItemID] = " & Nz(Me.ItemID, 0)) End Sub I can...

Excellent! thank you so much

Thank you! One thing I don't understand... you do not need to do the DlookUp and this Union query on the same QUery right?

Thank you all for your responses. How would I go about a Union SQL? I am not familiar unfortunately with this language. Thanks in advance,

Dear all, Trying to use a DLookUp formula in an update query to clean up a code There are 2 tables with the following: MainTable which Contains the fields: MainDirtyCode and MainCleanedCode CodeCleanUp which Contains the fields: DirtyCode and CleanedCode Update Query to modify...

yes, I think you got it Pat. It is an event I have that updates the date in the field based on a subform of the actions. The BeforeInsert even does not work for me because I need this macro to update after I change something on the subform of actions. I am looking to see which one could help me.

Hello, I deleted that filted as I don need it and it still does it. Sorry, how do I check that regarding the master/child links? thanks

Hi, thanks for the quick response, yes there are existing records to display. The Date Entry proerty is set to "No" The record source is another table called "ACTIONS" See print-screen Thanks again