Recent content by CosmicKid

Syntax problem it was: Me.subfrmAccountAdd1.[CompanyID] = AddCompID Me.subfrmAccountAdd1.[AccountNumber].SetFocus replaced with: Me.subfrmAccountAdd1.Form!CompanyID = AddCompID Me.subfrmAccountAdd1.Form!AccountNumber.SetFocus Thanks all!

Thanks for the tip, Gizmo. As I suspected, the offending code is: Me.subfrmAccountAdd1.[CompanyID] = AddCompID but sadly, I'm still stumped. I've set AddCompID as an integer and both CompanyID fields in the two tables are set to long integer...I must be missing something.

Hi All, I'm sure this issue has come up elsewhere on the forum, but I can't find a solution...any help would be most appreciated. Overview is this - I have a form showing records of company info and a subform where the user can enter an account number associated with that company. The main...

After a bit of hair-pulling I manage to work out the problem. Thought I would post it for review. The problem seemed to be I was passing the NewData to the specified field of the 1st record in the table, not the new record. Works great now. In the main form I have the following vb: Private...

hmm...still not working. I believe I need to pass the user entered data (newdata) using the openargs function, but I can't get it to work.

Hi All, Stumped on the following VB script - I have a form (frmCircuitsMainEntry) with a combo box that access a field called "CircuitVendor". When the user enters a vendor name that isn't associated with a record, the following message is displayed - "user text" is not in the database. Do...

That was a point I missed. All is clear now and works great. Much Thanks PBaldy! - CK

Excellent idea, but I don't want the form to switch to the selected record until the user dbl clicks on the field. Essentially, the field shows the primary key of a related record. By dbl-clicking on the field, the form will then jump to that record. Thanks.

Hi all - Probably a quick cure for this, but my VB skills are a little pathetic. I have a form based on a table with a field that allows the user to select the primary key of another record within that table. I used a combo box to do this. When the user dbl-clks on the field I would like...

great info - thanks. The subform idea was what I was missing. Works as planned now. CK

Hi all, I have a form for entry of telecom circuit info. The bulk of the info is stored in table "Circuits_Table". The table needs to access another table twice to display contact info for contacts on both the A and Z end of the line. This info resides in a table "Contacts_Table", pk is...