Search results for query: *

Russ, it works !!! for years i cheated by doing "go to previous record, go to next record" until a colleague gave me this solution and it works. I have a form1 (order/Invoice) with a subform1 (list of articles ordered), I have a button that open a new form2 that display the articles, I...

yes ! you are right, sorry ! you need to refresh form1. Set frmCurrentForm = Forms("Form1") Marc

I had the same problem. The solution is to insert following code in the "on close" event of your Form2 Private Sub Form_Close() Dim frmCurrentForm As Form Set frmCurrentForm = Forms("Form2") frmCurrentForm.Refresh End Sub

simply: Like "*" & [Forms]![nameofyourform]![look up employee] & "*"

the scanner will send data just as would the keyboard. Depending on the scanner you need a little interface program like BC-Wedge (www.taltech.com) which will make your scanner work just like info where entered on the keyboard (specially if the scanner is on port COM). Once the scanner works...

from [form 1] you open [form 2] on wich you display specific data. On [form 1] you add a command button that open [form 2]. [form 2] is based on a query. In that query, on the field you want to "select" or "filter" you add in the criteria (example) "Like...

When I have to many fields and subform on a form I use the "tab control" tools when I create the form. It's simple, clear and standard. It allows you to have many pages, sort the fields by subject....very conveniant.

you must have had a corruption on your table due to a network problem while working on the database or a pc not shut down properly. Try to repair/compact the file. Try also to create a new file and to reimport all the table/query...etc