Search results for query: *

Works great! I knew there had to be a simple way to tell if it is a new record. Thanks again PH.

I am running MS ACCESS 2003 SP3. I have run into a (probably very easy) problem that I couldn't find an answer to when searching the posts. I am using the "On Current" event to try and detect if the item being entered is a new item. Because I don't know any other way to tell it "On new...

That worked perfectly PHV! Thanks again!

Thanks for the reply Remou. The code I'm using is what I was have used on a number other forms successfully (came from a previous post on this forum), but I never tried using it to reference a subform with it. Now I am just trying to adopt it to fit with the subform. I'm fairly new at coding...

I am using ACCESS 2002 SP3 and running into a problem. In the main form the user selects an item type from a drop-down list. If it is equal to Equipment or Vehicle then select fields are supposed to appear in a subform embedded on the main form. The area where I'm having difficulty is trying...

Sorry for the delay in responding, I was out over the weekend and just got back. I tried the new coding and it works for the most part. There are two problems that I'm trying to overcome now: [tab]1) It only opens to one item that matches based on the criteria of disposal request number and...

Yes; the Item table (upon which frmItem is based) has DisposalReqOffice and DisposalReqNum as fields that come from the Disposal Request table as foreign keys. In the form these two fields have "cbo" in front of their name, but are otherwise the same.

You were on the right track with both responses, I had two separate issues; -the first was opening frmItem to display only records that matched frmDisposalRequest on two fields (DisposalReqOffice and DisposalReqNum) -the second was setting the default value of the form to equal the fields...

Still doing the same thing, it just opens the frmItem to a blank form where I can add new records. Any other ideas suggestions?

In establishing a request to move items out of a particular office, a Disposal Request form is filled out. The table "Disposal Request" is keyed off the Office # and the Disposal Request # (Disposal Request # starts at 1 for each office, thus it can't be a standalone key). The Item Table has...

That was it, thanks for your help! I've been working on trying to resolve that for a while now, it's good to finally be able to move on (to the next issue I'm sure :) ). -Steve

I replaced my reference with the recommendation of [Forms]![frmSales]![subfrmSales].[TransferNum] (the parent form's name is "frmSales"), but the pop up still appeared. This time it also appeared if I opened the sub form on its own. Thanks for the tip, any other ideas?

On my Sales Form I have basic information on the sales event (who bought it, how it was shipped, shipping method, etc...). I have put as a subform the items associated with that sale. For each item included in the sale, they must select where the item they are trying to bring in came from by...

Thanks for the advice PHV and TheAceMan1! Given a time crunch to get this project done PHV's workaround fixed it quickly. In the future I'll use the method you recommended TheAceMan1. Thanks again to both of you! -Steve

I am using the "On Current" and "After Update" events on a form to display select fields, depending on what type of transfer the user selects. This works fine up until I go to add a new record, at that point I get a "Run-Time Error '13' Type Mismatch" error message. I've looked into this a...

Thanks Trevil, that worked great!

I am trying to bind the first column to one field and the second column to a different one, by using the afterupdate event of my combo box. I know it has to be easy, but I don't know what coding to use to assign the value of my second column to another bound text box on my form within that...

Sorry for my misunderstanding on what you were looking for, thanks for the clarification Jazzz and PHV. TransferType was a textbox; its data type was a text field. It was brought into the form using a join on Item # (the unique key for the Item table) between the Item Table and a query that...

TransferType is based off a query that only brings up "State Surplus" transfers and then feeds into the Items form. I brought this field in to determine if the item was engaged in at least one "State Surplus" transfer type. Because one item can be involved in multiple different types of...

I meant to let you know that the run time error was pointing to the line: Me!InventoryNum.Visible = (Me!TransferType = "Surplus Store")