InterGladiator
Registered User.
- Local time
- Today, 16:00
- Joined
- Apr 20, 2006
- Messages
- 20
Hi,
I am new to program Access by Visual Basic. Please help me to solve the following task.
In my database I have a datatable containing lots of orders identified by their unique order numbers. I also have a form that contains three objects: a text box, a push button and a subform that shows the orders (order numbers, order dates etc.) in datasheet view. I would like the form work like this:
1) User enters an order number into the text box.
2) User clicks the search push button.
3) The subform jumps to the record containing the order number entered into the text box if founds it or displays "not found" error message if does not.
Please write me the simplest possible code to include in the Click Event of the push button. I guess I should use the Dataset.Seek method but I don't know how.
Thank you in advance,
Attila
I am new to program Access by Visual Basic. Please help me to solve the following task.
In my database I have a datatable containing lots of orders identified by their unique order numbers. I also have a form that contains three objects: a text box, a push button and a subform that shows the orders (order numbers, order dates etc.) in datasheet view. I would like the form work like this:
1) User enters an order number into the text box.
2) User clicks the search push button.
3) The subform jumps to the record containing the order number entered into the text box if founds it or displays "not found" error message if does not.
Please write me the simplest possible code to include in the Click Event of the push button. I guess I should use the Dataset.Seek method but I don't know how.
Thank you in advance,
Attila