New to microsoft access, need help!!!

[hannah8990]

Hi,

I'm new to Microsoft access and I need help, I need to create a table that allows me to type a certain name in to a field for instance supplier name, then for the whole block to move to another table that will store all the data for that one supplier and then delete the record from the original table.

Any help would be much appreciated

Thanks

 

[gemma-the-husky]

that doesn't sound right at all

what are you actually trying to achieve?

 

[micks55]

I'm an idiot (who Dave has helped, thanks again Dave) but even I think your plan sounds weird. Why would you do that?
You could use an unbound text box for the user input then click a button to append it to the table. Check out CurrentDB.Execute "INPUT INTO tblsupplier ... ;" and put that in the OnClick event of the button.
You need to disable the button until there is a valid entry in the text box and you should think about avoiding duplicates of the same supplier.

 

[galaxy]

I'm not sure what you're trying to do either. If you only want to see records from one supplier, the best way to do that is to create a query. All of your suppliers are in the same table, but the query filters them by supplier. If you really, really need another table, you can use a make-table query. I have no idea why you'd want to delete the record from the original table - can you tell us?