InfoPath Dev

I used a Data Connection to connect to a single table in an Access database, but I can't seem to get the 'preceding-sibling' functionality to work.Would like to be able to use information from the last record in a database to autopopulate a new record with the same information.  The new record will have some information ...

This is the code I have so far but the editor is kicking out an error that says: Name 'CreateObject' is not declared    Public Sub CTRL1_5_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs) Dim appAccess As ObjectappAccess = CreateObject("Access.Application") ...

I bought a device that sends keystrokes to the computer when someone passes their security card over it (we are logging in who attended a meeting) If I put my cursor into the right field, the keystrokes populate this field.  The shortcut keystroke of CTRL-ENTER is not an option on this device How can I program Infopath to insert a new row ...