form/table question

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I have a form that is an input form that will add values to a table, I
have it where it'll pop up the table in the form, but is there away to
have a new recordset be shown instead of showing the first recordset
in the table? hopefully this is easy.

Ryan
 
Ryan

I'm not clear from your description what is happening...

Are you saying that the first record in the table is showing when the form
opens?

What do you mean by "have a new recordset be shown" ... does that mean you
want to use the form to add a new record?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ok, sorry for not being clear. I have a popup form that shows a table.
This is my input form to add/delete records to the table. When I bring
up the form it'll automatically show record 1, can I have it
automatically show a "new" record where I can just input new
information in instead of clicking a ADD RECORD button to make it go
to a "new" record. This make sense?
 
Ryan

I'm not familiar with the construction you describe.

By chance, are you using a datatable view rather than a single form view?

One of the potential problems with using a datatable view is that folks see
something that looks like a spreadsheet and expect it to behave similarly.

Another potential issue may be (remember, no experience using that) whether
you have a way to validate data entry. Entering data directly into the
table does not provide any mechanisms for validation, which a single form
view does provide.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Ok, sorry for not being clear. I have a popup form that shows a table.
This is my input form to add/delete records to the table. When I bring
up the form it'll automatically show record 1, can I have it
automatically show a "new" record where I can just input new
information in instead of clicking a ADD RECORD button to make it go
to a "new" record. This make sense?
 
Back
Top