Running a module from a button in a form

[Sardamil]

I'm making a small database to help a friend. In this database he needs to track customers and their appointments. For this I created a form to enter custumerdetails and appointments. Both are added to their respective tables using a macro. The customernumber is an automatic number of the table customer. The max number is shown on the form, using a query to select that number. Every time the macro is executed I need to requery te form to refresh the max number. This works when using shift-F9, but I couldn't get this working so I converted the macro and added a requery statement to the code. Now I'm looking for a way to run my module when clicking a button on my form. Unless somebody can show me a way to requery my form after executing the macro.

 

[Sardamil]

I'm not sure if I posted this in the correct forum. Could somebody please move it to the correct forum? Thanks.

 

[Andrzejek]

Why do you need to show the customernumber on the Form? If it "is an automatic number of the table customer" and user can not change it (that's good), why do they care what number it is?

Have fun.

---- Andy