Search results

Syntax error (missing operator) in query expression. Where is it missing? DoCmd.OpenReport stDocName, acPreview, , "[ID]=forms!Booking Sheet[ID] & [Car Number]=forms!Test![Test]![Car Number]" Thanks.

I'm having trouble defining the proper relationships between tables so that fields in a form and subform will function properly. I have a field named Record Number in my main form. I can get Record Number to display in the subform. What I'm having trouble with is also a field named ID that is...

Thanks for the advice. My actual database uses different names, I just used those as examples. What I need help with is getting only the current form and current subform to display in a report. The two forms are linked by a field named "Booking Sheet Number". The unique field on the subform...

I'd like to thank Wayne for his previous help, but I think I need to better explain my problem. I have a form with a subform. I need to design a query to open a report that will display only the current form and subform. I've been able to display the current form, but all subforms are...

How do I get a report to display only the current form and subform displayed on the screen?

I figured it out. I added a Recordsource and it seems to work. Thanks for all the help :) Private Sub lstResults_AfterUpdate() DoCmd.OpenForm "Booking", RecordSource = "Booking", acNormal, "[Booking Sheet Number] = " & lstResults.Column(0) End Sub

still can't get it right Tried that. It didn't make a difference. The form always opens with record 1 rather than the record I need. Any more suggestions?

Here it is.

Thanks for the help, but I'm still not getting it. I've posted a much simplified version of my dbase. I can see that it didn't post. I'll try again.

I've double checked and the unique ID is in the first column. I'll post my example database if you can tell me how. Thanks.

help with code I've created a search form where the user presses a command button and the possible matches are displayed in a list box. The user should then be able to click on the correct response in the list box to bring up the correct record in a form. I've used the following code posted...

My apologies for asking a question that has been asked many times before on this site. I've tried the codes and downloaded examples, however I'm still just not getting it. I have a form named Booking Sheet with fields [Last] and [First] among others. I would like to make a separate form to...

I need help with printing the information in an open form as a report. I only want the current record to print as a report opposed to all of the records. I'd just print the form but the form takes up way more paper. I was also wondering how to get the gridlines in the report to print? Thanks...

I'm having trouble with what I know is a simple code. I have text controls: $1, $5, $10 etc in a form. The user is to input the quantity of each bill in possession. I then need the form to display the total dollar amount. What should I type in the Control Source property? Example: He has...

Thanks You guys are great!

I'm using the expresstion =[Money1]+[Money2] to sum two fields. However, I also need the expresstion to over rule the addition and make the total display 0 if a checkbox named "no bond" is checked. Any help would be great. Thanks.

How do I make the -1's and 0's in my table created by unbound option groups, display the words "yes" or "no" respectively? Thanks for the help.