Recent content by rui_jc

I got it... simply changed the way the condition is typed... before... If Me.Form![stage change]![stage] <> "NEW" Then Me.Form![stage change]![datein] = Me.DATA end if DID NOT WORK But i tryed this... If Me.Form![stage change]![stage] = "NEW" Then GoTo jump Me.Form![stage...

With a message box... If Me.Form![Datain subform1]![stage] = "new" Then 'Me.Form![Datain subform1]![stage] = "old MsgBox " new" End If does not apear any msg. It's like it's not detecting or the if is not working. I have the subform and it's data visible for testing and i can see that the...

No error, nothing. It just doesnt want to write...

Does these codes work for access 2002 ???? After writing the code... If Me.subform1.Form!stage <> "NEW" Then Me!subform1.Form!stage = "NEW" Me!subform1.Form!stagedate = Now() End If It's the same as I have... 'If Me.subform1.Form!stage <> "NEW" Then ' Me!subform1.Form!stage = "NEW" '...

Greetings to all, can you help me with this? I have a main form linked with a subform ( m/child ) query and I'm trying to make this code to work but it does not and I don’t know why. I have this code… Me.Form![subform1]![type] = Me.Combo12 Me.Form![subform1]![DESIGN] = Me.Combo11...

Greetings to all, I have a main form working with one invisible subform in the background that is linked by CarID field and i need to order by code in the main form to add a new record to the subform. The idea is this: 1- When "new record" button is pressed in main form and typed the carID...

I know a way to find the last entry for this ID. I used this code in the subform ( that is linked with the ID with the main form like you said): Private Sub carID_AfterUpdate() DoCmd.FindRecord Me.carID, , , acDown, , acCurrent End Sub now, when the user presses the save button on the main...

Thanks very much for your help, :) But what i need is that on a main form ( that records in table X ) has a subform ( invisible and working with table Y ). Imagine that it's for cars and the ID is the licence plate. In the main form the user types data like plugs, wires, etc. The subform...

My key is the ID. The Idea is to have a main Form that when the ID is typed, the subform does the job automaticaly with code while the main form stores other data.

Greetings to all, :) i have a database with a few tables, but i need a special one that stores initial date and final date for a particular ID, but like this... :confused: The table has the folowing fields; ID,STAGE,INITIALDATE,FINALDATE New record: ID1 - STAGE - INITIAL DATE -...