Recent content by DevinM21

ok so i sorta made something that kinda works Private Sub Form_Current() If Me.Deleted = True Then MsgBox "This record is deleted, Moving you to the next" If Me.CurrentRecord > previousRecord Then previousRecord = Me.CurrentRecord DoCmd.GoToRecord acDataForm, "new1", acNext Else If...

Am explaining this good? or does anyone not know? I just need to know if there is a name for a variable that holds what record number yuo just moved from. i'm on record number 1 in form view, i click arrow at the bottom to goto next, i'm now at record 2. k. I feel confident i'm explaining...

yes that' exactly what i'm wanting to do. if [current record number] > [record number you just came from] then goto Next record Else if [current record number] < [record number you just came from] then goto previous record end if the problem is idk how to reference [record number you just...

I don't know how to word this in a google search, it i kinda early here. I'm writing this code where if you go from record 1 to reord 2 and record 2 is deleted a mesage box will pop up saying "this record is deleted moving you to the next" and that works, but when i'm at record 5233 and going...

Ok Great Idea, That seems like less work. I'll do that. Thank you

I have an Idea, Tell me if this is possible with Access. I have a front end Databse file and a backend filr, backend has two tables, Front end has Main form for the first table and subform for the second table. Thinking of creating a nother datbase file with two of the same tables in it, but...

That's not the only reason.

Thank you guys for your time and answers btw. I really appreciate the help. : )

I cannot get them to fire if i open the subform by itself, and i'm sorry I can't post the database. oh but i need help so bad. i'm looking into detecting a subform event from main form procedure. idk how to do that yet though.

actually i can't get any events from the subform to work. What could be the reason for that? now i can get the control on the main form for the subform to work, it has two events to choose from. on open vent and on exit event. those I can display a MsgBox with. but on the form's event's...

I've tried the afterupdate event also. the 'msbBox "Hey"' still gives the same error.

ok yea i tried a simple Msgbox "Hey" and it gave the same error message.

Hello : ) I've tried a ton of different ways to go about this and i'm completly stumped. I have a main form with subform. On the Subform's beforeupdate event i want to change somehting on the mainform. so my code looks liek this: Private Sub Form_BeforeUpdate(Cancel As Integer)...