Re: Pulling data from a form into a subform

Tech-Archive recommends: Fix windows errors by optimizing your registry

Is empID the key field in the table? Is there a one-to-many relationship between csmEMPID in the table its being stored in and empID in its table? If so, do you have referential integrity setup?

Steveo99 wrote:
When a user wants to create a new record in my I want to pull over the Employees ID. My code doesn't generate an error, but it is not working. It is:

Me!csmEMPID.Value = Me.Parent!empID.Value

Any thoughts?


.

Relevant Pages

  • Re: Dates
    ... I have a table of employees - EmpID & EmpName ... I have a table or wage rates for each employee - RateID, EmpID, WageRate ... how on earth do I do a query to give me EmpName, DatePaid, HoursWorked. ...
    (comp.databases.ms-access)
  • Re: query question: How to select Parent and Child (in same table) bas
    ... CREATE TABLE Employees ... empname varcharNOT NULL, ... SELECT empid, mgrid, empname, salary, ...
    (microsoft.public.sqlserver.server)
  • Error Message
    ... I keep getting an error message when trying to select an entry from a Combo ... Here's the contents of table Employees: ... EmpID Emp_Name Job_Title Dept Notes ...
    (microsoft.public.access.formscoding)
  • Re: Totally Confused
    ... Employees table, but data remains in tblKeysEmployees. ... The juction table has 2 primary keys: ... KeyID and EmpID ...
    (microsoft.public.access.gettingstarted)
  • Re: employee manager query
    ... CREATE TABLE Employees ... RETURNS int ... RETURN @empid ... DECLARE @mgrid AS int ...
    (microsoft.public.sqlserver.programming)