I have a access 97 table called tbl_groups. There is a field (Auto Numbered) called Ga_Record_ID and set to auto number. I have another field called Ga_Record_ID_2 where I would like ga_record_id to be filled be filed automatically. That means when end user add a record access will automatically assign ga_record_id b/c it is a auto number field. The same number should appear in Ga_Record_ID_2 field. Ga_Record_ID_2 field is a text field. Any prompt help will be appreciated.
>> reply: the suggession using form would not work. I would like to have the value input permanently in ga_record_id_2 (text field) which should be same value as ga_record_id (auto number field).
>> I want this change to take place in the table. End user will not see in the form. Nor it's related to any of my form. I DON'T THINK LAST TWO RESPOND HELPED ME RESOLVED THE ISSUE. ANY PROMPT HELP WILL BE APPRECIATED.
>> Ok, may be i was not clear. I am using ACCESS 97. i wanna put something for this field ga_record_id_2 in the table design mode. we are not talking about form, report or any of that.
>> Finally it worked. I had to create another form in order to get this function work. I used the form_boforeinsert and it worked. THANKS A MILLIONS FOR ALL THE SUPPORT AND PROMPT HELP.
It will copy the value of Ga_Record_ID to Ga_Record_ID_2 for the current record only if you insert the statement into the Form_BeforeInsert Sub (open the code window for the form). Maybe you are referring to an update query? This is a different thing. BTW, in VBA you don't use ':=' but '=' for assigning a value to a variable.
Originally posted by War
Not understanding what you are trying to do here....
In the name of the field will repeat all values of the original Ga into Ga2.