Recent content by DLF

Pat - Thank you very much - you gave me a better way of looking at the problem. It works great now!

This is my first attempt at using a Union Query - Any help would be greatly appreciated! I have 5 fields I'm combining from two tables: SELECT [AcctNumber],[ReqNumber],[ReqDate],[Description1],[SupplierName] FROM [tblRequisitions] UNION SELECT...

First tried your code and found it was returning all 1's for the ReqNumber field - strange I didn't vary much from your code. Here's what I have: Dim DmaxReturn As Integer If IsNull(DMax("ReqNumber", "tblRequisitions", "AcctNumber = " & AcctNumber.Value)) Then Me.ReqNumber.Value = 1...

I guess that is my first question - should I base this off a query or can it be calculated directly into the field on my form as it all resides in the same table that the form is based on? The form is based on tblRequisitions.......... I want to select AcctNumber [combobox76] and return the max...

Hi everybody, I've fairly new to access and don't have a CLUE where to begin with this - I'm more than willing to do some research but I don't even know what to look for. I have a tblOrders; tblAccounts In my form I have a combobox to select the "account" number assigned to the order. Each...

godofhell ~ That worked perfectly! Thanks for the assistance - greatly appreciated!!!!!!! Diana

Well, I guess with a little trial and error it's working. I used MStef's requery idea and put the code event in the Combobox "on enter" property. I'm just wondering if the tblSupplier gets large (which is populating the Combobox) if it will slow the form down any?? Thanks for the...

SJ - I've tried both Me.Dirty and CmdSaveRecord - both act the same. The first change in the subform will update the combobox. The 2nd time the subform is accessed it doesn't update the combobox. The record IS being saved to the table, however...... URGGGGGG........

MStef, Help!! I'm a newbie to Access - where would I place this code? Main form? Subform? Thanks loads!!!

I have a form called NewRequisitions that had a combobox in which the users select the Supplier (name, address, shipping details). I created a button to open a subform called NewSupplier so that they can add a new supplier to the Supplier table as needed. My code works okay for the first...