[MS_AccessPros] Run an append query automatically

 

Dear All,

Is that possible to click on a command button run an append query automatically without pop up windows. For example:

source table: tblBooking

BookingID Roomtype NumberOfRooms

Destination table: tblCityRoomBooking

CityRoomBookingID CityTourID RoomType NumberOfRooms

By cliecking on a command button on the frmCityTour, I want to append "RoomType, NumberOfRoom" into tblCityRoomBooking, and I hope the "CityTourID" will be filled according to "CityTourID" from frmCityTour. 

Can this be done? Thanks.

Best Regards,

Kevin

---

Regards,

Kevin Zhao

__._,_.___

---

Posted by: "zhaoliqingoffice@163.com" <zhaoliqingoffice@163.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___