Recent content by chappie2

That's right. I have text boxes for the various fields from each table on the form. Chapppie.

Your approach may work Steve, but I am not familiar enough with VB to understand what it is doing and why? As an alternative, could I simply open the newly created record and include a command button which would update any of several fields which were blank? This seems more straight forward to...

I have worked with your coding, but can't make it work. A couple of issues; 1) I had intended to associate this with click on a command button which opened a new form - so would I simply add your coding to the correct private sub? Where would the Do Loop go relative to the Save Record and...

Thanks Steven. I'm willing to try DAO.recordsets, but need some basic guidance about how to set that up. Can you suggest some coding and how it would relate to the coding I already have? Thanks, Chappie

My db has two relevant tables, tblGrantee and tblGrantSum. TblGrantSum is a child of tblGrantee with DLCDGrant# as the primary and foreign key in the tables. Both tables have a "StreetAddress" field in them because the same street address is not always used by a Grantee. My form simply lists...

I have created the following code to open the appropriate linked record in a related table or to create a new record if a record does not exist. Dim ProgType As String ProgType = [Forms]![frmtest].[ProgramType] If ProgType = "Competitive" Then If IsNull(DLookup("[Grant#]", "tblCT"...

I am struggling moving from macros to VB. Here is the setup. I have three linked tables. tblGrantSum has info about all grants. Tables tblCTrack and tblFTrack have tracking information about some of the grants. Their is a one-to-one relatinship between tblGrantSum and the two tracking...

Thanks for pushing me AceMan. It may be painful but needs to be done! Let's go back to the beginning. My application has three main tables. A GrantSum table for summary information about all grants, CTrack to track detailed information about competitive grants and FTrack to track similar...

AceMan, Thanks for the input. I can't change the primary key without doing serious damage to the application. For now, let's just say that the two tables are linked and that there will be only one CTrack record for each GrantSum record (without defining the link as a one-to-one relationship)...

Based on what I believe was good advice, I created my database with something I don't fully understand and it is now coming back to haunt me. I have two tables: tblGrantSum and tblCTrack. The primary key of each is an autogenerated number. Each table also has a Grant# field, which is the link...

Thanks, that is exactly how I finally got it to work. I have identified at least four different ways that a sort could be applied to a report: 1) from an originating query, 2) from the "Order By" property of an originating form, 3) settings in Sorting and Grouping of the report, and 4) in...

I need some help with writing a macro or code to either open or create a new record in the following situation. My Grants application has three tables: grantsum contains information on all grants; FTrack is for tracking the fairly simply process of awarding formula grants; CTrack is for...

Thanks for your help and patience!! Let me see if I understand the code you provided earlier and shown below - it says that if the value of the grpSort field is "Name", sort it in one way and if it is "Company" sort it as shown in case 2. Select Case Forms!frmChooseSort!grpSort Case 1...

I have tried a couple of alternatives, but no "luck" so far. I tried your suggestion, but don't think I fully understood it. The followup led to a popup box rather than simply using the order by established in the form. Someone suggested the following: With Forms!frmGrantSumView...

I was so pleased to make major progress, that I missed one element. How do I pass the display order (sort) from the form on to the report? Lloyd