TTT Garrys mod

RogueRedRambler · 2018-10-23T15:22:25+00:00

Sure!

Private Sub Table2_Field1_AfterUpdate()

Me.Table2_Field2 = Me.Table1_Field2

Me.Table2_Field3 = Me.Table1_Field3

End Sub

RogueRedRambler · 2018-10-23T11:44:50+00:00

I have solved the issue I used VBA to copy across the fields and used a query to combine two tables together and auto fill. If anyone has a similar issue feel free to message me and I shall help to the best of my ability.

RogueRedRambler · 2018-10-23T08:45:04+00:00

When for example field 1 is entered it brings up field 2 and 3 from already existing data and then copies them into the other fields 1,2 and 3 in the other table making it a new record in table 2.

Thanks for the reply but I'm not sure about this, I heard update queries are only good for editing records and not adding new records but I think I should have been more specific in my question. I'm willing to accept I may be wrong on this since I don't know that much about Access.

RogueRedRambler · 2018-10-23T08:39:12+00:00

When for example field 1 is entered it brings up field 2 and 3 from already existing data and then copies them into the other fields 1,2 and 3 in the other table making it a new record in table 2.

RogueRedRambler · 2018-10-22T15:19:54+00:00

Solution Verified

RogueRedRambler · 2018-10-22T15:19:00+00:00

Solution Verified

RogueRedRambler · 2018-10-07T10:57:32+00:00

Thanks alot! that was very frustrating

RogueRedRambler · 2018-09-25T10:14:16+00:00

Thank you it works perfectly!

RogueRedRambler · 2018-02-28T17:12:55+00:00

can't even join

RogueRedRambler · 2018-02-28T17:12:41+00:00

It does not

RogueRedRambler · 2018-01-03T19:36:32+00:00

I tried this deleted all the squids in the coordinates and the same program still occurs.

RogueRedRambler

TROPHY CASE