Add Record Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry to keep bombarding these forums, I am trying to learn Access with a ‘on
the job assignment’ and it is proving a little more difficult than I thought.
I regard myself as an expert on Excel and VBA for Excel but I still cant
quite get my head around Access.

I have a form with a list box which displays a list of Company Entities. I
have a Delete Record button which works perfectly. I am trying to add an add
record button to the form, I thought I would have a unbound text box which I
could type the new Entity in and then transfer it to the table via VB – Is
this the best way of doing it or is there a simpler way? Also could someone
either provide me with some sample code or point me in the direction for this
kind of thing?
 
Hi Edgar,

The easiest way to do this would be to open a form which is bound to the
table for Company Entities. The form wizard will do most of the work for
you.

You could do this using unbound controls and DAO or ADO code, it's not that
hard but for a simple form I'd let Access do most of the work (via a bound
form).
 
Back
Top