need help with form?

[Parula]

Ok I am creating a database for a restaurant. This database is going to keep track of all the customers and the business transaction. The customer’s part keeps track of all the frequent customers and customer’s birthday and anniversary. In the for I created I would like the user to enter in a zip code that will give the user number of customer that are in that zip code for 6 different criteria. Once the user get the number of count. I could like the user to be able to enter in a number that will append to a table for all the different criteria. I also have a table called transaction that keeps trace off all the transaction and that table has a field called date. I would like to automatically have that field be updated when the query or the form is run.

The other problem is that I can’t format that for to get info from the user and return me the total for a zip code that the user entered. How do I do that?

How do I get the number of records that the user wants to send to the particular table?

 

[LonnieJohnson]

Here is an example of how you can get the number of records with a certain zip code to show up in a text box as a result of choosing from your combobox list. This can be done in the combo box's After Update Event:

Private Sub ComboBoxName_AfterUpdate()
TextBox = DCount("ZipCodeFieldName", "TableName", _
"ZipCodeFieldName = '" & ComboBoxName & "'&quot
End Sub

The zipCodeFieldName would be the name in the table. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Parula]

Hi Lonnie

i will try this but if it doesn't work can i email your my project and see if you can help me?

 

[LonnieJohnson]

Sure ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Parula]

hi Lonnie

i tried to email yout he file but it was to large so i get my self a storage space online. It's at

http://www.idrive.com.

i email you the password and username at you yahoo address.

thanks a million
parula